Re: [sqlite] sqlite_exec query string maximum length?

2006-09-18 Thread Kervin L. Pierre
Hello, Thanks for the explaination. Looks like this isn't going to help me after all. Thought sqlite3_exec() would compile the query only once. Best regards, Kervin --- Dennis Cote <[EMAIL PROTECTED]> wrote: > Kervin L. Pierre wrote: > > and for performance, I would like to execute as > > few

Re: [sqlite] sqlite_exec query string maximum length?

2006-09-18 Thread Kervin L. Pierre
Hello, Thanks. Best regards, Kervin --- [EMAIL PROTECTED] wrote: > "Kervin L. Pierre" <[EMAIL PROTECTED]> wrote: > > what is the maximumm number > > of characters there can be in a query > > string sent to sqlite_exec()? > > 2147483647 bytes > > -- > D. Richard Hipp <[EMAIL PROTECTED]> >

Re: [sqlite] sqlite_exec query string maximum length?

2006-09-18 Thread Dennis Cote
Kervin L. Pierre wrote: and for performance, I would like to execute as few sqlite_exec() calls as possible. Kervin, While you can pass several SQL statements to sqlite3_exec in one sql string, each statement is compiled and executed separately, so the performance increase over separate

Re: [sqlite] sqlite_exec query string maximum length?

2006-09-17 Thread drh
"Kervin L. Pierre" <[EMAIL PROTECTED]> wrote: > what is the maximumm number > of characters there can be in a query > string sent to sqlite_exec()? 2147483647 bytes -- D. Richard Hipp <[EMAIL PROTECTED]> - To

[sqlite] sqlite_exec query string maximum length?

2006-09-17 Thread Kervin L. Pierre
Hello, My application is building a query string with multiple queries. The number of queries depends on the user and for performance, I would like to execute as few sqlite_exec() calls as possible. So my question what is the maximumm number of characters there can be in a query string sent to