Would it make more sense to put the values into a text file and import the text file? It separates the data from the application, and simplifies making future changes to the list.
On Thu, Feb 23, 2012 at 1:52 PM, Abhinav Upadhyay < er.abhinav.upadh...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users