Documentation Source Text

Check-in [d399230aae]
Login

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.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: d399230aae6349da30b57944d5464376ad144773
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/pragma.in.

   181    181   
   182    182   Pragma cache_size {
   183    183       <p>^(<b>PRAGMA cache_size;
   184    184          <br>PRAGMA cache_size = </b><i>Number-of-pages</i><b>;</b></p>
   185    185       <p>Query or change the suggested maximum number of database disk pages
   186    186       that SQLite will hold in memory at once per open database file.)^  Whether
   187    187       or not this suggestion is honored is at the discretion of the
   188         -    [sqlite3_pcache_methods | Application Defined Page Cache].   ^In the
   189         -    default page cache implementation, the actual cache size is the
   190         -    greater of the suggested cache size and 10.
          188  +    [sqlite3_pcache_methods | Application Defined Page Cache].
   191    189       Alternative application-defined page cache implementations
   192    190       may choose to interpret the suggested cache size in different ways
   193    191       or to ignore it all together.
   194    192       ^The default suggested cache size is 2000.</p>
   195    193   
   196    194       <p>^The suggested cache size is set to the absolute value of the
   197    195       <i>Number-of-pages</i> argument given to this pragma.</p>
................................................................................
   890    888       ^(The second column is the "main" for the main database file, "temp"
   891    889       for the database file used to store TEMP objects, or the name of the
   892    890       ATTACHed database for other database files.)^
   893    891       ^(The third column is the name of the database file itself, or an empty
   894    892       string if the database is not associated with a file.)^</p>
   895    893   }
   896    894   
   897         -LegacyPragma foreign_key_list {
          895  +Pragma foreign_key_list {
   898    896       <p>^(<b>PRAGMA foreign_key_list(</b><i>table-name</i><b>);</b></p>
   899    897   
   900         -    DISCLAIMER
   901         -
   902    898       <p>This pragma returns one row for each foreign key that references
   903    899       a column in the argument table.)^
   904    900   }
   905    901   
   906    902   Pragma freelist_count {
   907    903       <p>^(<b>PRAGMA freelist_count;</b></p>
   908    904       <p>Return the number of unused pages in the database file.)^ ^Running