I didn't expect this 2 to 1 speed difference, and have no explanation for why it occurs. Does anyone else have an idea what might be happening?
Wild guess: SQLite does some optimizations on temporary tables to make them go faster - optimizations it can only get away with because temporary tables do not have to survive a power failure, OS crash, or program crash. Perhaps these optimizations are not being enabled correctly when you start a new database.
What OS are you using?
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
