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 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.
|