Re: [sqlite] sqlite3_prepare16_v3 and prepFlags

[Bart Smissaert]

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 
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
> >  sqlitepreparepersistent>
> > flag
> > instead of a zero. I have tried both options
> > with a plain select statement producing some 10 rows. Both worked and
> > SQLITE_PREPARE_PERSISTENT
> >  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

Re: [sqlite] sqlite3_prepare16_v3 and prepFlags

[Nico Williams]

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
> 
> flag
> instead of a zero. I have tried both options
> with a plain select statement producing some 10 rows. Both worked and
> SQLITE_PREPARE_PERSISTENT
> 
> 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] sqlite3_prepare16_v3 and prepFlags

[Bart Smissaert]

Using 3.20.0 now on Windows and wonder when exactly I should use the
SQLITE_PREPARE_PERSISTENT

flag
instead of a zero. I have tried both options
with a plain select statement producing some 10 rows. Both worked and
SQLITE_PREPARE_PERSISTENT

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