On 9 Apr 2010, at 11:57am, Igor Tandetnik wrote: > Christoph Walser, ETH Zurich wrote: >> Is there a way to do all the 5000 rows in one transaction to minimize >> database locking time? I know I can do a sqlite3_exec with "BEGIN >> TRANSACTION", then do the inserts and then "COMMIT TRANSACTIONS" but how >> does this work when using the bind, step and reset functions? > > Yes it does.
Just to make it clear, Igor is recommending that you do explicitly call BEGIN TRANSACTION do the 5000 inserts END TRANSACTION as this will speed up your calls and reduce the amount of disk activity quite a lot. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users