/ Check-in [ca1ff707]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

Overview
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
SHA3-256: ca1ff70780e07e5ee930fe7972db02e887d9b085d8ab78e878d7f966b6d684d4
User & Date: drh 2017-06-15 16:45:23
Context
2017-06-15
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

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