Documentation Source Text

Check-in [4bfef7edb7]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix typos in the cache_spill pragma documentation.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:4bfef7edb7fa904e0184913e04a17c579863e9b4
User & Date: drh 2013-08-20 17:06:48
Context
2013-08-23
01:57
Add documentation for the query_only and defer_foreign_keys pragmas. Update the change log for the 3.8.0 release. check-in: 8e16497ef1 user: drh tags: trunk
2013-08-20
17:06
Fix typos in the cache_spill pragma documentation. check-in: 4bfef7edb7 user: drh tags: trunk
2013-08-19
14:26
Fix a typo in the RTREE documentation. check-in: 9ceaba9f7f user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/pragma.in.

   213    213       bindings that do not provide direct access to [sqlite3_busy_timeout()].
   214    214   }
   215    215   
   216    216   Pragma cache_spill {
   217    217       <p>^(<b>PRAGMA cache_spill;
   218    218            <br>PRAGMA cache_spill=</b><i>boolean</i><b>;</b>)^</p>
   219    219   
   220         -    <p>^(The cache_spill pragme enables or disables the ability of the pager
          220  +    <p>^(The cache_spill pragma enables or disables the ability of the pager
   221    221       to spill dirty cache pages to the database file in the middle of a 
   222    222       transaction.)^  ^(Cache_spill is enabled by default)^ and most applications
   223         -    should leave it that way as cache spilling is unusally advantageous.
          223  +    should leave it that way as cache spilling is usually advantageous.
   224    224       However, a cache spill has the side-effect of acquiring an
   225    225       [EXCLUSIVE lock] on the database file.  Hence, some applications that
   226    226       have large long-running transactions may want to disable cache spilling
   227    227       in order to prevent the application from acquiring an exclusive lock
   228    228       on the database until the moment that the transaction [COMMIT]s.
   229    229   }
   230    230