Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Session Module C/C++ Interface
(session.html)
... values of all new rows inserted into the table.
It also records the original primary key and other column values of any
deleted or updated rows. For each unique primary key value, data is only
recorded once - the first time ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
... This means that for many common cases where the temporary tables
and indices are small (small enough to fit into the page cache)
no temporary files are created and no disk I/O occurs. Only
when the temporary data becomes ...
|
|
How SQLite Is Tested
(testing.html)
... The table-name hash table degenerates into a linked-list
and so the table-name lookups that occur while parsing SQL statements
might be a little slower, but the end result will be the same.
To work around this problem ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
... And each SALES table row references a single entry in the
various dimension tables. A dimension table row might reference
many thousands of SALES table rows, on the other hand.
This is a classic example of a star-schema. Data ...
|
|
SQLite Older News
(oldnews.html)
... This release also contains some important enhancements to the query planner
which should (we hope) make some queries run faster. The enhancements
include:
When doing a full-table scan, try to use an index instead of
the original table, under ...
|
|
SQLite FTS5 Extension
(fts5.html)
... CREATE TABLE %_docsize(id INTEGER PRIMARY KEY, sz BLOB);
-- Contains the actual data inserted into the FTS5 table. There
-- is one "cN" column for each indexed column in the FTS5 table.
-- This shadow table is not present for contentless or ...
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
... This is an important property for
applications where a software fault could cause injury, physical harm, or
loss of irreplaceable data.
4.1. Computing and controlling parameters M and n
The Robson proof applies separately to each of the memory ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... The xWrite method writes iAmt bytes of data from the second parameter
into the file beginning at an offset of iOfst bytes. If the size of
the file is less than iOfst bytes prior to the write, then xWrite should ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
... Flatten the subquery into its outer query
Evaluate the subquery into a transient table that exists for
the duration of the one SQL statement that is being evaluated,
then run the outer query against that transient table.
Evaluate the subquery ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... EndCoroutine
Insert
Write an entry into the table of cursor P1. A new entry is
created if it doesn't already exist or the data for an existing
entry is overwritten. The data is the value MEM_Blob stored in register ...
|
Page generated by FTS5 in about 126.69 ms.