Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add to the file-format documentation the constraint that stat3 and stat4 samples must be ordered. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
fad8e07e2650aa2b0534313362845d42 |
| User & Date: | drh 2014-10-06 15:08:52 |
Context
|
2014-10-07
| ||
| 12:40 | Add the not-found.html page. (check-in: 2e2274895f user: drh tags: trunk) | |
|
2014-10-06
| ||
| 15:08 | Add to the file-format documentation the constraint that stat3 and stat4 samples must be ordered. (check-in: fad8e07e26 user: drh tags: trunk) | |
| 03:07 | In althttpd.c: Fix a bug such that HTTPS requests are correctly logged as such. If the "--https 1" command-line option is used, then try to read the remote IP address from the REMOTE_HOST environment variable, under the assumption that althttpd is being called from stunnel. (check-in: c34e8da80a user: drh tags: trunk) | |
Changes
Changes to pages/fileformat2.in.
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
....
1450
1451
1452
1453
1454
1455
1456
1457
1458
1459
1460
1461
1462
1463
|
number of distinct left-most entries in the index that are less than
the sample.)^
<p>^There can be an arbitrary number of sqlite_stat3 entries per index.
The [ANALYZE] command will typically generate sqlite_stat3 tables
that contain between 10 and 40 samples that are distributed across
the key space and with large nEq values.
<tcl>hd_fragment stat4tab {sqlite_stat4} SQLITE_STAT4</tcl>
<h4>2.6.6 The sqlite_stat4 table</h4>
<p>The sqlite_stat4 is only created and is only used if SQLite is compiled
with [SQLITE_ENABLE_STAT4] and if the SQLite version number is
3.8.1 or greater. The sqlite_stat4 table is neither read nor written by any
................................................................................
index whereas the sqlite_stat4 table provides information about all columns
of the index.
<p>^There can be an arbitrary number of sqlite_stat4 entries per index.
The [ANALYZE] command will typically generate sqlite_stat4 tables
that contain between 10 and 40 samples that are distributed across
the key space and with large nEq values.
<tcl>hd_fragment rollbackjournal {rollback journal format}</tcl>
<h2>3.0 The Rollback Journal</h2>
<p>The rollback journal is a file associated with each SQLite database
file that hold information used to restore the database file to its initial
state during the course of a transaction.
|
>
>
>
>
>
>
>
>
>
>
>
>
>
|
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
....
1457
1458
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
|
number of distinct left-most entries in the index that are less than the sample.)^ <p>^There can be an arbitrary number of sqlite_stat3 entries per index. The [ANALYZE] command will typically generate sqlite_stat3 tables that contain between 10 and 40 samples that are distributed across the key space and with large nEq values. <p>^(In a well-formed sqlite_stat3 table, the samples for any single index must appear in the same order that they occur in the index. In other words, if the entry with left-most column S1 is earlier in the index b-tree than the entry with lef-most column S2, then in the sqlite_stat3 table, sample S1 must have a smaller rowid than sample S2.)^ <tcl>hd_fragment stat4tab {sqlite_stat4} SQLITE_STAT4</tcl> <h4>2.6.6 The sqlite_stat4 table</h4> <p>The sqlite_stat4 is only created and is only used if SQLite is compiled with [SQLITE_ENABLE_STAT4] and if the SQLite version number is 3.8.1 or greater. The sqlite_stat4 table is neither read nor written by any ................................................................................ index whereas the sqlite_stat4 table provides information about all columns of the index. <p>^There can be an arbitrary number of sqlite_stat4 entries per index. The [ANALYZE] command will typically generate sqlite_stat4 tables that contain between 10 and 40 samples that are distributed across the key space and with large nEq values. <p>^(In a well-formed sqlite_stat4 table, the samples for any single index must appear in the same order that they occur in the index. In other words, if entry S1 is earlier in the index b-tree than entry S2, then in the sqlite_stat4 table, sample S1 must have a smaller rowid than sample S2.)^ <tcl>hd_fragment rollbackjournal {rollback journal format}</tcl> <h2>3.0 The Rollback Journal</h2> <p>The rollback journal is a file associated with each SQLite database file that hold information used to restore the database file to its initial state during the course of a transaction. |