татко Крокодил

For everyone using like me evolution under Ubuntu Intrepid (8.10), you might’ve seen how slow it is. Here’s a fix that solves at least part of the problem (it’s two orders of magnitude faster, at the level of the previous one).

Find all you folders.db files, go in their directories and run:

for i in `sqlite3 folders.db .tables`; do sqlite3 folders.db "CREATE INDEX IF NOT EXISTS 'junk_$i' ON '$i' (junk)"; done
for i in `sqlite3 folders.db .tables`; do sqlite3 folders.db "CREATE INDEX IF NOT EXISTS 'del_$i' ON '$i' (deleted)"; done
for i in `sqlite3 folders.db .tables`; do sqlite3 folders.db "CREATE INDEX IF NOT EXISTS 'read_$i' ON '$i' (read)"; done

The problem evidently is that they forgot to make indexes on the tables (a rookie mistake). There are open bug #292739 in launchpad and bug #558883 in the gnome bugzilla.

This entry was posted on Thursday, November 6th, 2008 at 12:03 and is filed under General. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.