After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 568194 - SQLite index is big and slow
SQLite index is big and slow
Status: RESOLVED FIXED
Product: evolution
Classification: Applications
Component: Mailer
2.24.x (obsolete)
Other Linux
: Normal normal
: ---
Assigned To: evolution-mail-maintainers
Evolution QA team
evolution[disk-summary]
Depends on:
Blocks: 543389
 
 
Reported: 2009-01-18 17:03 UTC by Hans Petter Jansson
Modified: 2009-01-30 03:31 UTC
See Also:
GNOME target: ---
GNOME version: 2.23/2.24



Description Hans Petter Jansson 2009-01-18 17:03:17 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.
Comment 1 Hans Petter Jansson 2009-01-18 17:03:51 UTC
Also, searches and vFolders are just as slow as before and Evolution uses slightly more RAM.
Comment 2 Akhil Laddha 2009-01-19 04:17:16 UTC
could be dupe of bug 548826
Comment 3 Srinivasa Ragavan 2009-01-20 08:47:46 UTC
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.
Comment 4 Hans Petter Jansson 2009-01-20 12:44:58 UTC
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.
Comment 5 Srinivasa Ragavan 2009-01-20 13:12:19 UTC
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?
Comment 6 Hans Petter Jansson 2009-01-20 22:16:25 UTC
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.
Comment 7 Srinivasa Ragavan 2009-01-29 17:02:43 UTC
Is this still valid with 2.24.3?
Comment 8 Hans Petter Jansson 2009-01-30 00:31:27 UTC
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...
Comment 9 Hans Petter Jansson 2009-01-30 00:33:45 UTC
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 :)
Comment 10 Srinivasa Ragavan 2009-01-30 03:31:12 UTC
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