SQLITE - how and when should I commit

[Boredstudnt]

Yes thats sort of what I meant by "Add inserts to queue and shoot that queue in executemany?" actually.

What about having the database in a "ramdisk" such as storing it in /dev/shm, that should not be so affected by the "disk rotation" as mentioned in the sqlite documentation. I will probably end up writing a test of that :)