Documentation Source Text

Check-in [f61736804d]
Login

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: f61736804de85e9d3a6eeffe8a2553f2b7bfe7cd
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
Unified Diff Ignore Whitespace Patch
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.