Documentation Source Text

Check-in [afd9f7a1c4]
Login

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

Overview
Comment:Fix for CVSTrac ticket #3031 - typo in atomic commit document.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: afd9f7a1c417596ed420fa8af8b3f6f2de4ce98d
User & Date: drh 2008-04-08 05:30:59.000
Context
2008-04-15
01:32
Update the keyword list. CVSTrac ticket #3054. (check-in: 1b43c0419c user: drh tags: trunk)
2008-04-08
05:30
Fix for CVSTrac ticket #3031 - typo in atomic commit document. (check-in: afd9f7a1c4 user: drh tags: trunk)
2008-03-18
14:07
Fix an HTML syntax error in the common page footer. CVSTrac ticket #3004. (check-in: e21302f6df user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/atomiccommit.in.
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
some future release of SQLite.  But for now (version 3.5.0) the
rollback journal truncation optimization is only enabled in conjunction
with exclusive access mode.</p>

<h3>7.3 Do Not Journal Freelist Pages</h3>

<p>When information is deleted from an SQLite database, the pages used
to old the deleted information are added to a "freelist".  Subsequent
inserts will draw pages off of this freelist rather than expanding the
database file.</p>

<p>Some freelist pages contain critical data; specifically the locations
of other freelist pages.  But most freelist pages contain nothing useful.
These latter freelist pages are called "leaf" pages.  We are free to
modify the content of a leaf freelist page in the database without







|







911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
some future release of SQLite.  But for now (version 3.5.0) the
rollback journal truncation optimization is only enabled in conjunction
with exclusive access mode.</p>

<h3>7.3 Do Not Journal Freelist Pages</h3>

<p>When information is deleted from an SQLite database, the pages used
to hold the deleted information are added to a "freelist".  Subsequent
inserts will draw pages off of this freelist rather than expanding the
database file.</p>

<p>Some freelist pages contain critical data; specifically the locations
of other freelist pages.  But most freelist pages contain nothing useful.
These latter freelist pages are called "leaf" pages.  We are free to
modify the content of a leaf freelist page in the database without