Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Enhance the file format description to allow unrecognized text tokens at the end of the stat column in sqlite_stat1. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
3e1aad19c5fd84d6c6d9beb7b97760c6 |
| User & Date: | drh 2014-07-22 12:24:10 |
Context
|
2014-07-24
| ||
| 13:50 | Add documentation about the readfile() and writefile() extension functions in the command-line shell. Additional command-line shell documentation updates. check-in: d4097ee3bf user: drh tags: trunk | |
|
2014-07-22
| ||
| 12:24 | Enhance the file format description to allow unrecognized text tokens at the end of the stat column in sqlite_stat1. check-in: 3e1aad19c5 user: drh tags: trunk | |
|
2014-07-18
| ||
| 19:06 | Clarify that PRAGMA wal_autocheckpoint always causes a PASSIVE checkpoint. Provide clearer definitions for PASSIVE, FULL, and RESET checkpoints. check-in: 306698cb1d user: drh tags: trunk | |
Changes
Changes to pages/fileformat2.in.
1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 |
by a token of the form "sz=NNN" where NNN is an unsigned integer. The
"sz=NNN" token, if present, must be separated from the last integer by a
single space. ^The "sz=NNN" token means that the average row size over all
records of the table or
index is NNN bytes per row. ^The SQLite query planner might use the
estimated row size information provided by the "sz=NNN" token
to help it choose smaller tables and indexes that require less disk I/O.
<p>If the sqlite_stat1.idx column is NULL, then the sqlite_stat1.stat
column contains a single integer which is the approximate number of
rows in the table identified by sqlite_stat1.tbl.
<tcl>hd_fragment stat2tab {sqlite_stat2}</tcl>
<h4>2.6.4 The sqlite_stat2 table</h4>
|
> > > > |
1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 |
by a token of the form "sz=NNN" where NNN is an unsigned integer. The "sz=NNN" token, if present, must be separated from the last integer by a single space. ^The "sz=NNN" token means that the average row size over all records of the table or index is NNN bytes per row. ^The SQLite query planner might use the estimated row size information provided by the "sz=NNN" token to help it choose smaller tables and indexes that require less disk I/O. <p>New text tokens may be added to the end of the stat column in future enhancements to SQLite. For compatibility, unrecognized tokens at the end of the stat column are silently ignored. <p>If the sqlite_stat1.idx column is NULL, then the sqlite_stat1.stat column contains a single integer which is the approximate number of rows in the table identified by sqlite_stat1.tbl. <tcl>hd_fragment stat2tab {sqlite_stat2}</tcl> <h4>2.6.4 The sqlite_stat2 table</h4> |