Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Dynamic Memory Allocation In SQLite
(malloc.html)
4.1. Computing and controlling parameters M and n
... SQL table rows that contain large strings or BLOBs.
Complex SQL queries that compile down to large prepared statements.
SQL parser objects used internally by sqlite3_prepare_v2().
Storage space for database connection objects.
Page cache memory allocations that overflow into the ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.7. The copy method
... File-name must exist, and
each row must contain the same number of columns as defined in the table.
If a line in the file contains more or less than the number of columns defined,
the copy method rollbacks any ...
|
|
Database File Format
(fileformat.html)
2.6. Storage Of The SQL Database Schema
... CREATE TABLE sqlite_schema(
type text,
name text,
tbl_name text,
rootpage integer,
sql text
);
The sqlite_schema table contains one row for each table, index, view,
and trigger (collectively "objects") in the database schema, except there
is no entry for the sqlite_schema ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
14. Automatic Query-Time Indexes
... If each table contains N rows, SQLite expects that
the subquery will run N times, and hence it will believe it is faster
to construct an automatic, transient index on t2 first and then use
that index to satisfy the ...
|
|
Command Line Shell For SQLite
(cli.html)
11. Recover Data From a Corrupted Database
... value of rowid field, or NULL
c0, c1, c2, c3... -- columns for fields of row
);
The "lost_and_found" table contains one row for each orphaned row recovered
from the database. Additionally, there is one row for each recovered index
entry that ...
|
Page generated by FTS5 in about 19.40 ms.