Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
c_prepare_normalize.html

Index Summary Markup Original


R-43443-20296-62064-61017-62025-48147-54408-20485 tcl slt th3 src

SQLITE_PREPARE_PERSISTENT 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.

/* IMP: R-43443-20296 */
# EVIDENCE-OF: R-43443-20296 SQLITE_PREPARE_PERSISTENT 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-58809-52102-21271-42089-25495-26496 tcl slt th3 src

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.

/* IMP: R-50230-26466 */
# EVIDENCE-OF: 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.