On Tue, 2009-06-23 at 18:28 +0200, Romuald Brunet wrote: > After a bit of exploring the folders.db sqlite file, I've found out > that there is an index on every table named SINDEX-table that is an > index for *every* column in the table. > > In practice, that means that the index will never be used, since it > would require a query mixing all those fields (or at least, the first > ones in order : uid, flags, size, .. ) > > It also means that the index will take unnecessary place on the > filesystem (in my case, that was around 100MB by the time I removed > them), and slow down inserts into the database (in my case, when > moving a lots of mails from a folder to another).
Have any of the Evo hackers looked at this email from Romuald? This seems like a simple change that should be made. Maybe a bugzilla entry is needed? _______________________________________________ Evolution-hackers mailing list Evolution-hackers@gnome.org http://mail.gnome.org/mailman/listinfo/evolution-hackers
