On Wed, 8 Sep 2010 21:03:05 -0700 (PDT), Hemant Shah <hj...@yahoo.com> wrote:
> I forgot to mention, that I have set pragma journal_mode to off > and for every insert I do prepare -> step -> finalize -> COMMIT. That's a weird sequence. Because you use the same statement all the time, you only have to prepare() once, and then for every INSERT: bind(); step(); reset(); clear_bindings(); Also, COMMIT doesn't make sense without a BEGIN. For speed, wrap several (or even many) INSERTs in one BEGIN / COMMIT pair. Without BEGIN; COMMIT, every single INSERT is a transaction by itself. Finalize at program exit (or not at all). -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
