On 5 Jul 2009, at 2:02pm, Indiff3rence wrote: > Using the v2 version of prepare didn't help. I'm not sure how can I > use > sqlite_exec and 'BEGIN TRANSACTION' / 'COMMIT'. Can you please > provide an > example where you insert multiple entries to a DB.
Do the command 'BEGIN TRANSACTION'. Then do each of your 'INSERT' commands . Then do the command 'COMMIT'. Only when you do the 'COMMIT' does your database actually change. You can do any of these with _exec or by using _prepare, whichever you want. The page about it is here: <http://www.sqlite.org/lang_transaction.html> but it should be easy enough for you to try yourself. If you have lots of 'INSERT' commands, this should speed up the total amount of time it takes to execute them all. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
