Re: [sqlite] Limit on the Compound Select Statements

2012-02-24 Thread Don V Nielsen
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

Re: [sqlite] Limit on the Compound Select Statements

2012-02-23 Thread Abhinav Upadhyay
On Thu, Feb 23, 2012 at 6:50 PM, Simon Slavin wrote: > > On 23 Feb 2012, at 1:16pm, Abhinav Upadhyay > 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 Sqlit

Re: [sqlite] Limit on the Compound Select Statements

2012-02-23 Thread Richard Hipp
On Thu, Feb 23, 2012 at 8:25 AM, Petite Abeille wrote: > > On Feb 23, 2012, at 2:16 PM, Abhinav Upadhyay wrote: > > > . I was wondering if I could insert them using a > > single INSERT query > > Ah, also, there is not much benefit in using a compound insert. > > You could as well simply insert all

Re: [sqlite] Limit on the Compound Select Statements

2012-02-23 Thread Petite Abeille
On Feb 23, 2012, at 2:16 PM, Abhinav Upadhyay wrote: > . I was wondering if I could insert them using a > single INSERT query Ah, also, there is not much benefit in using a compound insert. You could as well simply insert all your values in one transaction and be done. On the other hand, the f

Re: [sqlite] Limit on the Compound Select Statements

2012-02-23 Thread Petite Abeille
On Feb 23, 2012, at 2:16 PM, Abhinav Upadhyay wrote: > I would like to know the exact limit > on this, so that I could my code to work within this limit :) See Maximum Number Of Terms In A Compound SELECT Statement: http://www.sqlite.org/limits.html ___

Re: [sqlite] Limit on the Compound Select Statements

2012-02-23 Thread Simon Slavin
On 23 Feb 2012, at 1:16pm, Abhinav Upadhyay 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 l

[sqlite] Limit on the Compound Select Statements

2012-02-23 Thread Abhinav Upadhyay
Hi, I have a single column table, in which I wish to store around several thousands of rows. I was wondering if I could insert them using a single INSERT query and came across this Stackoverflow answer: http://stackoverflow.com/a/1734067/348637 . According to that answer it is possible to insert m