Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Rowid Tables
(rowidtable.html)
... In particular the VACUUM command will
change rowids for tables that do not declare an INTEGER PRIMARY KEY.
Therefore, applications should not normally access the rowid directly,
but instead use an INTEGER PRIMARY KEY.
In the underlying file format, each ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... If you delete a lot of data and want to shrink the database file,
run the VACUUM command.
VACUUM will reconstruct
the database from scratch. This will leave the database with an empty
free-list and a file that is ...
|
|
Memory-Mapped I/O
(mmap.html)
... Hence, on Windows,
if an operation such as VACUUM or auto_vacuum tries to reduce the
size of a memory-mapped database file, the size reduction attempt will
silently fail, leaving unused space at the end of the database file.
No ...
|
|
Architecture of SQLite
(arch.html)
... attach.c,
auth.c,
build.c,
delete.c,
expr.c,
insert.c,
pragma.c,
select.c,
trigger.c,
update.c,
vacuum.c,
where.c,
wherecode.c, and
whereexpr.c.
In these files is where most of the serious magic happens ...
|
|
SQLite Keywords
(lang_keywords.html)
... ROLLBACK
ROW
ROWS
SAVEPOINT
SELECT
SET
TABLE
TEMP
TEMPORARY
THEN
TIES
TO
TRANSACTION
TRIGGER
UNBOUNDED
UNION
UNIQUE
UPDATE
USING
VACUUM
VALUES
VIEW
VIRTUAL
WHEN
WHERE
WINDOW
WITH
WITHOUT
This page last modified on 2022-11-26 14:56:19 UTC
|
|
Temporary Files Used By SQLite
(tempfiles.html)
2.9. Transient Database Used By VACUUM
The VACUUM command works by creating a temporary file
and then rebuilding the entire database into that temporary
file. Then the content of the temporary file is copied back
into the original database file and the temporary file is
deleted ...
|
|
C API: Database Connection Configuration Options
(c3ref/c_dbconfig_defensive.html)
SQLITE_DBCONFIG_MAINDBNAME, SQLITE_DBCONFIG_LOOKASIDE, SQLITE_DBCONFIG_ENABLE_FKEY, SQLITE_DBCONFIG_ENABLE_TRIGGER, SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ...
... SQLITE_DBCONFIG_RESET_DATABASE
Set the SQLITE_DBCONFIG_RESET_DATABASE flag and then run
VACUUM in order to reset a database back to an empty database
with no schema and no content. The following process works even for
a badly corrupted database file:
If the database ...
|
|
SQLite Backup API
(backup.html)
1.1. Other Backup Techniques
... The VACUUM INTO command will make a vacuumed copy of a live
SQLite database into a separate file.
The sqlite3_rsync program makes a copy of a live SQLite database
to or from a remote system using an SSH connection.
|
|
Imposter Tables
(imposter.html)
2.1.1. Corrupted Database
... This will not cause
any immediate problems, though one should avoid running VACUUM.
It is possible to write into the "t2" table, thus changing the content
of the index.
But doing so will get the "t1bc" index out of synchronization ...
|
|
The DBSTAT Virtual Table
(dbstat.html)
4. Example uses of the dbstat virtual table
... To find out what fraction of the pages in
a database are sequential (and thus obtain a measurement that might
be useful in determining when to VACUUM), run a query like the following:
CREATE TEMP TABLE s(rowid INTEGER PRIMARY ...
|
Page generated by FTS5 in about 64.25 ms.