Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|Comment:||Fix typo and improve the wording of the description of "Metadata" in the output of the sqlite3_analyzer tool.|
|Downloads:||Tarball | ZIP archive | SQL archive|
|Timelines:||family | ancestors | descendants | both | trunk|
|Files:||files | file ages | folders|
|User & Date:||drh 2017-06-15 16:45:23|
|16:56||Move the "shell_add_schema()" SQL function used by the ".schema" command of the command-line shell to a different spot in the shell.c source file so that it is not in the middle of an unrelated module. check-in: 254617a1 user: drh tags: trunk|
|16:45||Fix typo and improve the wording of the description of "Metadata" in the output of the sqlite3_analyzer tool. check-in: ca1ff707 user: drh tags: trunk|
|13:07||Fix harmless compiler warnings in the shell.c file check-in: 9afd7a2f user: drh tags: trunk|
Changes to tool/spaceanal.tcl.
762 762 The amount of payload stored under this category. Payload is the data 763 763 part of table entries and the key part of index entries. The percentage 764 764 at the right is the bytes of payload divided by the bytes of storage 765 765 consumed. 766 766 767 767 Bytes of metadata 768 768 769 - The amount of formatting and structural information stored on for the 769 + The amount of formatting and structural information stored in the 770 770 table or index. Metadata includes the btree page header, the cell pointer 771 771 array, the size field for each cell, the left child pointer or non-leaf 772 772 cells, the overflow pointers for overflow cells, and the rowid value for 773 - rowid table cells. In other words, metadata is everything that is not 774 - unused space and that is not content. 773 + rowid table cells. In other words, metadata is everything that is neither 774 + unused space nor content. The record header in the payload is counted as 775 + content, not metadata. 775 776 776 777 Average payload per entry 777 778 778 779 The average amount of payload on each entry. This is just the bytes of 779 780 payload divided by the number of entries. 780 781 781 782 Average unused bytes per entry