hi folks. i searched around a bit but didn't find anything on this topic.

i have this running in a script and scheduled using alarmed to run on a daily basis at 2am.

sqlite3 /home/user/.rtcom-eventlogger/el-v1.db 'VACUUM;'
sqlite3 /home/user/.rtcom-eventlogger/e1.db 'VACUUM;'
sqlite3 /home/user/.qmf/qmailstore.db 'VACUUM;'
sqlite3 /home/user/.calendar/calendardb 'VACUUM;'
sqlite3 /home/user/.config/hildon-desktop/notifications 'VACUUM;'
sqlite3 /home/user/.fmms/mms.db 'VACUUM;'

i have an uptime of 3 days now and it usually starts to lag noticeably (i use optimize n900). but the above seems to have made the phone quicker to respond. the fmms entry probably doesn't do anything for the phone overall but i just included it for fun.

here are some examples of phone being snappier:

1. microb is faster in opening multiple windows
2. launching xterm is faster
3. opening settings - there used to be a slight delay of about 2 to 3 seconds while the top of the window has a spinning icon. but it is now instant.
4. opening sms and email apps is much faster.
5. deleting smses is very much faster.

i don't understandm the effect of those dbs being compressed on overall performance and some of them don't seem related to e.g. microb or launching the settings app but this is what i observe.

anyway, just thought i'd share this and see if anyone else can benefit from it.

thanks.