> 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
