Not quite clear as point 9 in the release notes of 3.20.0 seems to me to suggest that this only applied if you are using FTS3, FTS5 or the R-Tree extension.
RBS On Wed, Aug 2, 2017 at 11:09 PM, Nico Williams <n...@cryptonector.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users