Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Remove an obolete requirement from the cache_size pragma. Un-deprecate the foreign_key_list pragma, since people seem to use it far more than we suspected. |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
d399230aae6349da30b57944d5464376 |
User & Date: | drh 2010-12-08 21:13:04 |
Context
2010-12-09
| ||
18:56 | Add documentation for the SQLITE_DEFAULT_WAL_AUTOCHECKPOINT compile-time option. Other updates to PRAGMA documentation. (check-in: 140df585c3 user: drh tags: trunk) | |
2010-12-08
| ||
21:13 | Remove an obolete requirement from the cache_size pragma. Un-deprecate the foreign_key_list pragma, since people seem to use it far more than we suspected. (check-in: d399230aae user: drh tags: trunk) | |
12:58 | Add a description of the file naming conventions to the download page. (check-in: 5610cee39b user: drh tags: trunk) | |
Changes
Changes to pages/pragma.in.
︙ | ︙ | |||
181 182 183 184 185 186 187 | Pragma cache_size { <p>^(<b>PRAGMA cache_size; <br>PRAGMA cache_size = </b><i>Number-of-pages</i><b>;</b></p> <p>Query or change the suggested maximum number of database disk pages that SQLite will hold in memory at once per open database file.)^ Whether or not this suggestion is honored is at the discretion of the | | < < | 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 | Pragma cache_size { <p>^(<b>PRAGMA cache_size; <br>PRAGMA cache_size = </b><i>Number-of-pages</i><b>;</b></p> <p>Query or change the suggested maximum number of database disk pages that SQLite will hold in memory at once per open database file.)^ Whether or not this suggestion is honored is at the discretion of the [sqlite3_pcache_methods | Application Defined Page Cache]. Alternative application-defined page cache implementations may choose to interpret the suggested cache size in different ways or to ignore it all together. ^The default suggested cache size is 2000.</p> <p>^The suggested cache size is set to the absolute value of the <i>Number-of-pages</i> argument given to this pragma.</p> |
︙ | ︙ | |||
890 891 892 893 894 895 896 | ^(The second column is the "main" for the main database file, "temp" for the database file used to store TEMP objects, or the name of the ATTACHed database for other database files.)^ ^(The third column is the name of the database file itself, or an empty string if the database is not associated with a file.)^</p> } | | < < | 888 889 890 891 892 893 894 895 896 897 898 899 900 901 902 903 904 | ^(The second column is the "main" for the main database file, "temp" for the database file used to store TEMP objects, or the name of the ATTACHed database for other database files.)^ ^(The third column is the name of the database file itself, or an empty string if the database is not associated with a file.)^</p> } Pragma foreign_key_list { <p>^(<b>PRAGMA foreign_key_list(</b><i>table-name</i><b>);</b></p> <p>This pragma returns one row for each foreign key that references a column in the argument table.)^ } Pragma freelist_count { <p>^(<b>PRAGMA freelist_count;</b></p> <p>Return the number of unused pages in the database file.)^ ^Running |
︙ | ︙ |