Hi, I do have multiple insertions bounded by BEGIN-COMMIT . I am looking at possibilities of making the insertions faster.
-Sreekumar On Tue, Nov 29, 2011 at 4:36 PM, Donald Griggs <dfgri...@gmail.com> wrote: > Sreekumar, > > Regarding: > > > > Is it possible to insert multiple rows using a single statement ? > > > > You might want to let us know your reasons for requesting this. > > If it's speed of insertion you're after, then be sure to put many INSERT's > into each transaction. That is, be sure to surround a batch of, say, 1000 > INSERT's with BEGIN and END statements. > > http://sqlite.org/lang_transaction.html > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users