/ Check-in [26577814]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Improvements to the documentation for SQLITE_PREPARE_PERSISTENT. No code changes.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 265778142485882f39edfb5756175b2675c1993f0d6395dabbcbbb3767c6ec77
User & Date: drh 2017-07-13 22:03:34
Context
2017-07-13
22:39
Improved documentation for the new sqlite3_bind_pointer() interface and its cousins. check-in: 889968bd user: drh tags: trunk
22:03
Improvements to the documentation for SQLITE_PREPARE_PERSISTENT. No code changes. check-in: 26577814 user: drh tags: trunk
20:11
Fix documentation typo. No changes to code. check-in: 9319f7b7 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/sqlite.h.in.

  3488   3488   ** "prepFlags" parameter of the [sqlite3_prepare_v3()] and
  3489   3489   ** [sqlite3_prepare16_v3()] interfaces.
  3490   3490   **
  3491   3491   ** New flags may be added in future releases of SQLite.
  3492   3492   **
  3493   3493   ** <dl>
  3494   3494   ** [[SQLITE_PREPARE_PERSISTENT]] ^(<dt>SQLITE_PREPARE_PERSISTENT</dt>
  3495         -** <dd>The SQLITE_PREPARE_PERSISTENT flag causes [sqlite3_prepare_v3()]
  3496         -** and [sqlite3_prepare16_v3()]
  3497         -** to optimize the resulting prepared statement to be retained for a 
  3498         -** relatively long amount of time.)^  ^Without this flag,
  3499         -** [sqlite3_prepare_v3()] and [sqlite3_prepare16_v3()] assume that
  3500         -** the prepared statement will be used just once or at most a few times
  3501         -** and then destroyed using [sqlite3_finalize()] relatively soon.
         3495  +** <dd>The SQLITE_PREPARE_PERSISTENT flag is a hint to the query planner
         3496  +** that the prepared statement will be retained for a long time and
         3497  +** probably reused many times. ^Without this flag, [sqlite3_prepare_v3()]
         3498  +** and [sqlite3_prepare16_v3()] assume that the prepared statement will 
         3499  +** be used just once or at most a few times and then destroyed using
         3500  +** [sqlite3_finalize()] relatively soon. The current implementation acts
         3501  +** on this hint by avoiding the use of [lookaside memory] so as not to
         3502  +** deplete the limited store of lookaside memory. Future versions of
         3503  +** SQLite may act on this hint differently.
  3502   3504   ** </dl>
  3503   3505   */
  3504   3506   #define SQLITE_PREPARE_PERSISTENT              0x01
  3505   3507   
  3506   3508   /*
  3507   3509   ** CAPI3REF: Compiling An SQL Statement
  3508   3510   ** KEYWORDS: {SQL statement compiler}