Re: [sqlite] Maximum result set size

2019-03-12 Thread Simon Slavin
On 12 Mar 2019, at 6:38am, niklas wrote: > Surely that works the same way as sqlite3_step in respect to memory use since > it's using step internally and just forwards the results to the callback > function of exec. > > Or did I miss something? You missed nothing. _exec() returns only the

Re: [sqlite] Maximum result set size

2019-03-12 Thread niklas
A clarification about sqlite3_exec please. Surely that works the same way as sqlite3_step in respect to memory use since it's using step internally and just forwards the results to the callback function of exec. Or did I miss something? -- Sent from: http://sqlite.1065341.n5.nabble.com/

Re: [sqlite] Maximum result set size

2019-03-11 Thread Simon Slavin
On 11 Mar 2019, at 8:32pm, Wout Mertens wrote: > Don't listen to me, Simon's answer is way better :) Your answer was absolutely correct. I just answered some other stuff too. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Maximum result set size

2019-03-11 Thread Tim Streater
On 11 Mar 2019, at 20:21, Simon Slavin wrote: > On 11 Mar 2019, at 7:30pm, Tim Streater wrote: > >> What is the maximum size in bytes that a result set may be? And what happens >> if that size were to be exceeded? > > [The following is simplified for clarity. I discuss only worst cases and >

Re: [sqlite] Maximum result set size

2019-03-11 Thread Wout Mertens
Don't listen to me, Simon's answer is way better :) Wout. On Mon, Mar 11, 2019 at 9:22 PM Wout Mertens wrote: > There is no fixed limit, and the sqlite API just walks through the > results, so any memory overrun that happens is due to application level > code. > > Wout. > > > On Mon, Mar 11,

Re: [sqlite] Maximum result set size

2019-03-11 Thread Wout Mertens
There is no fixed limit, and the sqlite API just walks through the results, so any memory overrun that happens is due to application level code. Wout. On Mon, Mar 11, 2019 at 8:30 PM Tim Streater wrote: > What is the maximum size in bytes that a result set may be? And what > happens if that

Re: [sqlite] Maximum result set size

2019-03-11 Thread Simon Slavin
On 11 Mar 2019, at 7:30pm, Tim Streater wrote: > What is the maximum size in bytes that a result set may be? And what happens > if that size were to be exceeded? [The following is simplified for clarity. I discuss only worst cases and ignore caching.] SQLite does not prepare an entire

[sqlite] Maximum result set size

2019-03-11 Thread Tim Streater
What is the maximum size in bytes that a result set may be? And what happens if that size were to be exceeded? -- Cheers -- Tim ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org