Simon Slavin-2 wrote: > > Forget all the fancy ways to speed up individual INSERT commands. You > could probably just use sqlite_exec. Your speed problem is probably > that you're not specifying that they're all the same transaction. Do > a 'BEGIN TRANSACTION' before the first one and a 'COMMIT' after the > last one. > > If you do want to use _prepare, try to use the _v2 versions of it and > check to see that you're using _finalize correctly. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >
Thanks for your reply. 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. Kind regards, Pedro Saraiva -- View this message in context: http://www.nabble.com/Rebind-Statement-tp24339026p24342912.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users