Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Session Module C/C++ Interface
(session.html)
... The
SAVEPOINT is committed if the changeset or patchset is successfully
applied, or rolled back if an error occurs. Specifying this flag
causes the sessions module to omit this savepoint. In this case, if the
caller has an open transaction ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... AutoCommit
Set the database auto-commit flag to P1 (1 or 0). If P2 is true, roll
back any currently active btree transactions. If there are any active
VMs (apart from this one), then a ROLLBACK fails. A COMMIT fails ...
|
|
SQLite FTS5 Extension
(fts5.html)
6.1. The 'automerge' Configuration Option
... Each time a new transaction is
committed, a new b-tree containing the contents of the committed transaction
is written into the database file. When the full-text index is queried, each
b-tree must be queried individually and the ...
|
|
Compile-time Options
(compile.html)
2. Recommended Compile-time Options
... Furthermore, transaction commit is much faster in WAL mode using
synchronous=NORMAL than with the default synchronous=FULL. For these
reasons, it is recommended that the synchronous setting be changed from
FULL to NORMAL when switching to WAL mode. This ...
|
|
How SQLite Is Tested
(testing.html)
3.3. Crash Testing
... A separate
white-paper titled
Atomic Commit in SQLite describes the
defensive measure SQLite takes to prevent database corruption following
a crash. Crash tests strive to verify that those defensive measures
are working correctly.
It is impractical to do crash ...
|
|
The sqlite3_analyzer.exe Utility Program
(sqlanalyze.html)
1.2. Example Output
... moz_items_annos',1,79,79,1,562,0,0,9,0,1,0,0,31961,0,0,32768);
INSERT INTO space_used VALUES('moz_keywords_placepostdata_uniqueindex','moz_keywords',1,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
COMMIT;
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
7.4. The "merge=X,Y" command
... Each "merge=X,Y" command will run in a separate
transaction (unless they are grouped together using BEGIN...COMMIT,
of course). The transactions can be kept small by choosing a value
for X in the range of 100 to 300 ...
|
Page generated by FTS5 in about 97.18 ms.