/ Check-in [31e5073c]
Login

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

Overview
Comment:Explanation of the "fragmentation" line is added to the help message at the end of the output of sqlite3_analyzer. (CVS 3636)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:31e5073c58f43b84d26218d70e6f6558c406803e
User & Date: drh 2007-02-13 01:41:53
Context
2007-02-13
02:03
Changes in preparation for version 3.3.13. (CVS 3637) check-in: 7799a0b6 user: drh tags: trunk
01:41
Explanation of the "fragmentation" line is added to the help message at the end of the output of sqlite3_analyzer. (CVS 3636) check-in: 31e5073c user: drh tags: trunk
01:38
Additional fixes to the new fragmentation feature of sqlite3_analyzer. (CVS 3635) check-in: 82aed271 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to tool/spaceanal.tcl.

   765    765   
   766    766   Average unused bytes per entry
   767    767   
   768    768       The average amount of free space remaining on all pages under this
   769    769       category on a per-entry basis.  This is the number of unused bytes on
   770    770       all pages divided by the number of entries.
   771    771   
          772  +Fragmentation
          773  +
          774  +    The percentage of pages in the table or index that are not
          775  +    consecutive in the disk file.  Many filesystems are optimized
          776  +    for sequential file access so smaller fragmentation numbers 
          777  +    sometimes result in faster queries, especially for larger
          778  +    database files that do not fit in the disk cache.
          779  +
   772    780   Maximum payload per entry
   773    781   
   774    782       The largest payload size of any entry.
   775    783   
   776    784   Entries that use overflow
   777    785   
   778    786       The number of entries that user one or more overflow pages.