Re: [sqlite] Sqlite2 vs Sqlite3 benchmark

[Dan Kennedy]

> 1) Why is sqlite2 faster than sqlite3 per transaction?

For SQLite 3, the default value of the 'synchronous' pragma 
changed from "NORMAL" to "FULL". IIRC this means the disk is 
synced 3 times instead of 2 for a small transaction. So this
might be what you're seeing. 

(Note that the documentation on the website has a bug - it
says the default value is NORMAL for both versions).



                
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Helps protect you from nasty viruses. 
http://promotions.yahoo.com/new_mail