I'm also curious, now that someone asked. If there is no limit, it is easy to just «mmap» a text file and let sqlite handle it (offcourse a few checks would be necessary).
Not that it's a much wanted feature, just a «cool» thing to do with sqlite ;) Regards, ~Nuno Lucas === On 2004-06-15, Shawn Anderson wrote === >Is there a reason you don't want to use a begin transaction, then insert >everything, then end the transaction? It is extremely efficient to do this. > > >Shawn > >-----Original Message----- >From: Xuer [mailto:[EMAIL PROTECTED] >Sent: Monday, June 14, 2004 11:56 PM >To: [EMAIL PROTECTED] >Subject: [sqlite] what's the character limit of a single sql in sqlite? > >could i use a long,long sql sentence to insert many items into a table once >without limit? >or there IS a limit so i have to accomplish it by doing it for multi times? > >thanks in advance.:) --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
