Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Change the defined default mask for PRAGMA optimize to 0xfffe. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
b4f5fcc3c82fe755c22392d7d46542ec |
User & Date: | drh 2017-03-07 00:51:37.312 |
Context
2017-03-07
| ||
13:08 | Merge the search form fix from the 3.17 branch. (check-in: 4a748fb25c user: drh tags: trunk) | |
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) | |
Changes
Changes to pages/pragma.in.
︙ | ︙ | |||
961 962 963 964 965 966 967 | information from the current session in the database file so that it will be available to "optimize" pragmas run by future database connections. <li value='8'><p> <em>(Not yet implemented)</em> Create indexes that might have been helpful to recent queries. </ol> | | | | > | > > | 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 | information from the current session in the database file so that it will be available to "optimize" pragmas run by future database connections. <li value='8'><p> <em>(Not yet implemented)</em> Create indexes that might have been helpful to recent queries. </ol> <p>The default MASK is and alway shall be 0xfffe. The 0xfffe mask means perform all of the optimizations listed above except Debug Mode. If new optimizations are added in the future that should be off by default, those new optimizations will be given a mask of 0x10000 or larger.</p> <p>To see all optimizations that would have been done without actually doing them, run "PRAGMA optimize(-1)".</p> <p><b>Determination Of When To Run Analyze</b></p> <p> In the current implementation, a table is analyzed if only if all of the following are true: <ul> <li><p> MASK bit 0x02 is set. |
︙ | ︙ |