>Also, do a large number of inserts within a transaction. (1000-100,000 or so, not a billion ;) )
I don't see how increasing the number of inserts per transaction changes the speed at which the sqlite3_step function executes when it is called on an insert in the middle of the transaction. I'll put some more commentary on that in my next response to Dennis.
