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.
RBS _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
