http://bugzilla.spamassassin.org/show_bug.cgi?id=3202
------- Additional Comments From [EMAIL PROTECTED] 2004-03-21 23:45 ------- Subject: Re: Replace DB_File with SQLite? On Sun, Mar 21, 2004 at 11:38:09PM -0800, [EMAIL PROTECTED] wrote: > > > Every single performance test I've done with SQLite I've stopped long > > before it finished because I didn't want to wait that long. My last > > test I stopped at about 5% done and it had already taken around 3 > > times longer than it was taking to do a complete run with DB_File. > > Did you optimize query for sqlite ? Create indexes and so on ? > Sometimes logic of operation with data needed to be changed to use advantages > of database. > Bayes queries are fairly optimized and work very well under other database setups. However, what I had not done is set is PRAGMA default_synchronous = OFF and upping the default_cache_size. I've done this now and it seems to be behaving much better. It does mean that we lose a little peace of mind as far as making sure data gets all the way to the disk. The SQLite docs say you can get a 50 times speed up turning it off. Interesting however, is that halfway through my mass-check test it's now slowed to a crawl. Michael ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee.
