On Wed, Aug 02, 2017 at 11:01:07PM +0100, Bart Smissaert wrote: > Using 3.20.0 now on Windows and wonder when exactly I should use the > SQLITE_PREPARE_PERSISTENT > <https://www.sqlite.org/c3ref/c_prepare_persistent.html#sqlitepreparepersistent> > flag > instead of a zero. I have tried both options > with a plain select statement producing some 100000 rows. Both worked and > SQLITE_PREPARE_PERSISTENT > <https://www.sqlite.org/c3ref/c_prepare_persistent.html#sqlitepreparepersistent> > seemed > a bit faster. Are there any clear guidelines > when to use either option? > Note I am not using FTS3, FTS5 or the R-Tree extension.
I thought the docs were clear: if you'll be executing the statement repeatedly, then use SQLITE_PREPARE_PERSISTENT. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users