Rod Dav4is <dav...@yahoo.com> wrote:
> *Insert rate*: 7/sec.

Run batches of inserts within a single transaction. It's not the insert 
itself that's slow, it's the process of committing a transaction. By not 
starting an explicit transaction, you commit an implict one on every 
statement.

Igor Tandetnik 



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to