Re: [Evolution-hackers] Index on sqlite database

[Paul Smith <paul mad-scientist us>]

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?