RB Smissaert wrote:
Analyzing the lookup table knocks the time down from 0.36 to 0.31 secs, something I didn't expect.
That shows the importance of testing. I ported the SQLite benchmarks to Python and was surprised to see some of the tests taking minutes to run versus a few (or a few tens of) seconds for the SQLite shell reading SQL from a file or the same wrapper executing the statements individually.
For a 100k line bulk insert (e.g., restoring from a .dump to a disk file) that could mean a slow down from about 25 seconds to over 5500 seconds, or 92 minutes...
Martin ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------