Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix typo in the pragma optimize documentation. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
f61736804de85e9d3a6eeffe8a2553f2 |
| User & Date: | drh 2017-03-06 23:14:17 |
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 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>For 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.
|
| |
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.
|