On 12 Mar 2019, at 6:38am, niklas <[email protected]> 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 same integer result code as most other API calls. It does not return the result from a SELECT, for example. Just as with individual calls to _step(), _exec() never has to accumulate a complete set of results. So it doesn't have to accumulate results in memory, using a lot of memory if there are a lot of results. You can make it call your callback with each row, one by one, but it does not remember the rows itself. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
