Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Frequently Asked Questions
(faq.html)
... You can use PRAGMA integrity_check
to do a thorough but time intensive test of the database integrity.
You can use PRAGMA quick_check to do a faster
but less thorough test of the database integrity.
Depending how badly your database is ...
|
|
C API: Checkpoint a database
(c3ref/wal_checkpoint_v2.html)
sqlite3_wal_checkpoint_v2()
... The PRAGMA wal_checkpoint command can be used to invoke this interface
from SQL.
See also lists of
Objects,
Constants, and
Functions.
|
|
DELETE
(lang_delete.html)
... Prior to SQLite version 3.6.5 (2008-11-12), the truncate optimization
also meant that the sqlite3_changes() and
sqlite3_total_changes() interfaces
and the count_changes pragma
will not actually return the number of deleted rows.
That problem has been fixed as ...
|
|
Atomic Commit In SQLite
(atomiccommit.html)
7.6. Persistent Rollback Journals
... SQLite can be configured to commit transactions by overwriting
the journal header with zeros instead of deleting the journal file
by setting the "PERSIST" journaling mode using the
journal_mode PRAGMA.
For example:
PRAGMA journal_mode=PERSIST;
The use of persistent journal ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
5.3. Update 2017: A Better Fix
... In 2017, Fossil was enhanced to make use of the new
PRAGMA optimize statement. Whenever Fossil is about to close the
database connection to its repository, it first runs
"PRAGMA optimize", which will in turn cause ANALYZE to be run ...
|
|
35% Faster Than The Filesystem
(fasterthanfs.html)
2.2. Write Performance Measurements
... The next chart shows the performance of SQLite versus direct-to-disk
when transactions are disabled (PRAGMA journal_mode=OFF)
and PRAGMA synchronous is set to OFF. These settings put SQLite on an
equal footing with direct-to-disk writes, which ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.22. The xIntegrity Method
If the iVersion for an sqlite3_module is 4 or more and the xIntegrity
method is not NULL, then the PRAGMA integrity_check and
PRAGMA quick_check commands will invoke
xIntegrity as part of its processing. If the xIntegrity method writes
an error ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... If the SHOW_DATATYPES pragma
is on (it is off by default) then
the second argc entries in the 4th argument are the datatypes
for the corresponding columns.
If the
EMPTY_RESULT_CALLBACKS pragma is set to ON and the result of
a ...
|
|
C API: Application Defined Page Cache.
(c3ref/pcache_methods2.html)
struct sqlite3_pcache_methods2
... This is the value configured using
the SQLite "PRAGMA cache_size" command. As with the bPurgeable
parameter, the implementation is not required to do anything with this
value; it is advisory only.
The xPagecount() method must return the number of pages ...
|
|
An Asynchronous I/O Module For SQLite
(asyncvfs.html)
... WAL mode with PRAGMA synchronous set to NORMAL avoids calls to
fsync() during transaction commit and only invokes fsync() during
a checkpoint operation. The use of WAL mode largely obviates the
need for this asynchronous I/O module. Hence, this ...
|
Page generated by FTS5 in about 129.39 ms.