On Thu, Feb 23, 2012 at 6:50 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 23 Feb 2012, at 1:16pm, Abhinav Upadhyay <er.abhinav.upadh...@gmail.com> > wrote: > >> I do not remember the >> exact error message but it close to this. As per the documentation on >> the compound select statements >> (http://www.sqlite.org/lang_select.html) on Sqlite website, there is >> no mention of an explicit limit. I would like to know the exact limit >> on this, so that I could my code to work within this limit > > <http://www.sqlite.org/limits.html> > > especially item 3, but also others. > > However, I question the advantage of doing one long INSERT rather than doing > many inside a transaction. Are you binding parameters ? >
It was already inside a bigger transaction, I was trying out something naive and turns out it is not worth it. Thanks for the pointer :) -- Abhinav _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users