Small. Fast. Reliable.
Choose any three.
#define SQLITE_PREPARE_PERSISTENT 0x01
These constants define various flags that can be passed into
"prepFlags" parameter of the sqlite3_prepare_v3() and
New flags may be added in future releases of SQLite.
- The SQLITE_PREPARE_PERSISTENT flag is a hint to the query planner
that the prepared statement will be retained for a long time and
probably reused many times.
R-50230-26466:[Without this flag, sqlite3_prepare_v3()
and sqlite3_prepare16_v3() assume that the prepared statement will
be used just once or at most a few times and then destroyed using
sqlite3_finalize() relatively soon.
The current implementation acts
on this hint by avoiding the use of lookaside memory so as not to
deplete the limited store of lookaside memory. Future versions of
SQLite may act on this hint differently.
See also lists of