On Sep 6, 2004, at 10:14 PM, Philipp K. Janert, Ph.D. wrote:
I am accessing sqlite from Python, using the pysqlite driver. I am loading all records first using cx.execute( "insert ..." ). Only once I have run cx.execute() for all records, I commit all the preceding inserts with conn.commit()
For a disk-based database, inserts in transactions are much faster than those not in transactions. So my first thought would be to wrap all of your inserts into one transaction. But since this is an in-memory database, I'm not sure if that still applies, though I'm betting it does.
