GNOME Bugzilla – Bug 568194
SQLite index is big and slow
Last modified: 2009-01-30 03:31:12 UTC
The new SQLite index in Evolution 2.24 does not appear to confer any benefits on me, but takes up 700MB disk space. Starting up and shutting down takes much longer and seems to be CPU-bound.
Also, searches and vFolders are just as slow as before and Evolution uses slightly more RAM.
could be dupe of bug 548826
Run this - http://www.gnome.org/~sragavan/evolution-rebuild-summarydb This vacuum's your folders.db I still need to see how I can seemlessly do it through Evolution. Infact post vaccuum its pretty fast. Loading folders was taking 50s to 2 secs, on dropping vm_caches. This also cuts down the size a lot. Just that I need to do this via Evolution programatically, on idle etc.
I already did that, and it didn't make a difference. The biggest folder.db shrunk from 700MB to 680MB and the performance characteristics didn't change.
HPJ, your issue of slowness would be partly fixed by 2.24.3. https://build.opensuse.org/package/show?package=evolution&project=home%3Ajjohnny%3Aevolution%3Astable is the project, we are building. EDS done. Evolution should be done today. Hmm, sqlite3 <folders.db> "vacuum" This is what that does. Then it might be 680MB really for the entire account, not sure how much it was. It carries summary, indices etc for the account. Is it a big account?
Evolution failed to build, so only evolution-data-server is available. Yeah, it's a big local mail account. Between 1GB and 2GB of mail spools.
Is this still valid with 2.24.3?
It's still slower than it used to be, but Evolution seems to use slightly less RAM. The folders.db file for my local folders is still huge, though...
OTOH, starting up and shutting down is tolerably fast in 2.24.3. I still wish it didn't have to regenerate my vfolders on startup, though. At this point I think only the big folders.db actually constitutes a regression, and that won't change as long as it's using SQLite. I guess you can close this bug FIXED or WONTFIX depending on your mood :)
HPJ, we sort of bloat the folders.db a bit to be search-able and sort-able. So it gotto be slightly bigger than ever before. Also the db brings in some more additions. The slow-ness is fixed :-) Thanks