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: | 31e5073c58f43b84d26218d70e6f6558 |
| 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
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.