Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix typo in the pragma optimize documentation. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
f61736804de85e9d3a6eeffe8a2553f2 |
User & Date: | drh 2017-03-06 23:14:17.761 |
Context
2017-03-07
| ||
00:51 | Change the defined default mask for PRAGMA optimize to 0xfffe. (check-in: b4f5fcc3c8 user: drh tags: trunk) | |
2017-03-06
| ||
23:14 | Fix typo in the pragma optimize documentation. (check-in: f61736804d user: drh tags: trunk) | |
21:03 | More typo fixes and enhancements to the 3.18 change log. (check-in: fc711f28f5 user: drh tags: trunk) | |
Changes
Changes to pages/pragma.in.
︙ | ︙ | |||
923 924 925 926 927 928 929 | <p>^(<b>PRAGMA optimize; <br>PRAGMA optimize(</b><i>MASK</i><b>); <br>PRAGMA </b><i>schema</i><b>.optimize; <br>PRAGMA </b><i>schema</i><b>.optimize(</b><i>MASK</i><b>);</b></p> <p>Attempt to optimize the database.)^ ^All schemas are optimized in the first two forms, and only the specified schema is optimized in the latter two.</p> | | | 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 | <p>^(<b>PRAGMA optimize; <br>PRAGMA optimize(</b><i>MASK</i><b>); <br>PRAGMA </b><i>schema</i><b>.optimize; <br>PRAGMA </b><i>schema</i><b>.optimize(</b><i>MASK</i><b>);</b></p> <p>Attempt to optimize the database.)^ ^All schemas are optimized in the first two forms, and only the specified schema is optimized in the latter two.</p> <p>To achieve the best long-term query performance without the need to do a detailed engineering analysis of the application schema and SQL, it is recommended that applications run "PRAGMA optimize" (with no arguments) just before closing each [database connection]. Long-running applications might also benefit from setting a timer to run "PRAGMA optimize" every few hours. </p> <p>This pragma is usually a no-op or nearly so and is very fast. |
︙ | ︙ |