Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| SHA1 Hash: | c48f8ffedc30841aa4994eb925d09c2ee97a864d |
|---|---|
| Date: | 2009-10-17 08:26:29 |
| User: | dan |
| Comment: | Add documentation comment for new experimental API sqlite3_reoptimize(). |
Tags And Properties
- branch=trunk inherited from [704b122e53]
- sym-trunk inherited from [704b122e53]
Changes
Changes to src/sqlite.h.in
5745 5745
5746 /* 5746 /*
5747 ** CAPI3REF: Optimizing for Bound Parameters 5747 ** CAPI3REF: Optimizing for Bound Parameters
5748 ** EXPERIMENTAL 5748 ** EXPERIMENTAL
5749 ** 5749 **
5750 ** If possible, optimize the SQL statement passed as the only argument 5750 ** If possible, optimize the SQL statement passed as the only argument
5751 ** for the values currently bound to the statements SQL variables. 5751 ** for the values currently bound to the statements SQL variables.
> 5752 **
> 5753 ** SQLite currently contains two optimizations that depend upon the values
> 5754 ** of SQL literals specified as part of a query:
> 5755 **
> 5756 ** <ul>
> 5757 ** <li> The [range query optimization], and
> 5758 ** <li> The [LIKE optimization].
> 5759 ** </ul>
> 5760 **
> 5761 ** Normally, queries that use an SQL [parameter] in the relevant expression
> 5762 ** or expressions may not benefit from either of the above optimizations.
> 5763 ** This function may be used to overcome this limitation.
> 5764 **
> 5765 ** Calling sqlite3_reoptimize() on a statement handle after values have been
> 5766 ** bound to its SQL parameters causes SQLite to inspect the query and the
> 5767 ** bound values to determine if either of the above optimizations may be
> 5768 ** applied to it. If so, a new query plan is formulated to take advantage
> 5769 ** of the optimizations.
> 5770 **
> 5771 ** If it is determined that neither of the above optimizations may be
> 5772 ** profitably applied to the query based on the values bound to SQL
> 5773 ** parameters, this function is a no-op.
5752 */ 5774 */
5753 int sqlite3_reoptimize(sqlite3_stmt *pStmt); 5775 int sqlite3_reoptimize(sqlite3_stmt *pStmt);
5754 5776
5755 /* 5777 /*
5756 ** Undo the hack that converts floating point types to integer for 5778 ** Undo the hack that converts floating point types to integer for
5757 ** builds on processors without floating point support. 5779 ** builds on processors without floating point support.
5758 */ 5780 */
Execute permission set for tool/fragck.tcl
Execute permission set for tool/mkopts.tcl
Execute permission set for tool/mkspeedsql.tcl
Execute permission set for tool/mksqlite3c.tcl
Execute permission set for tool/mksqlite3h.tcl
Execute permission set for tool/mksqlite3internalh.tcl
Execute permission set for tool/omittest.tcl
Execute permission set for tool/soak1.tcl
Execute permission set for tool/space_used.tcl
Execute permission set for tool/spaceanal.tcl
Execute permission set for tool/speedtest.tcl
Execute permission set for tool/speedtest2.tcl
Execute permission set for tool/vdbe-compress.tcl