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 |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
31e5073c58f43b84d26218d70e6f6558 |
User & Date: | drh 2007-02-13 01:41:53.000 |
Context
2007-02-13
| ||
02:03 | Changes in preparation for version 3.3.13. (CVS 3637) (check-in: 7799a0b63d 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: 31e5073c58 user: drh tags: trunk) | |
01:38 | Additional fixes to the new fragmentation feature of sqlite3_analyzer. (CVS 3635) (check-in: 82aed271a4 user: drh tags: trunk) | |
Changes
Changes to tool/spaceanal.tcl.
︙ | ︙ | |||
765 766 767 768 769 770 771 772 773 774 775 776 777 778 | Average unused bytes per entry The average amount of free space remaining on all pages under this category on a per-entry basis. This is the number of unused bytes on all pages divided by the number of entries. Maximum payload per entry The largest payload size of any entry. Entries that use overflow The number of entries that user one or more overflow pages. | > > > > > > > > | 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 | Average unused bytes per entry The average amount of free space remaining on all pages under this category on a per-entry basis. This is the number of unused bytes on all pages divided by the number of entries. Fragmentation The percentage of pages in the table or index that are not consecutive in the disk file. Many filesystems are optimized for sequential file access so smaller fragmentation numbers sometimes result in faster queries, especially for larger database files that do not fit in the disk cache. Maximum payload per entry The largest payload size of any entry. Entries that use overflow The number of entries that user one or more overflow pages. |
︙ | ︙ |