Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Books About SQLite
(books.html)
... It also describe how the
workings of SQLite, and in particular the journal and WAL, can be used
to ascertain what has happened in a manner that cannot be determined
from the data alone. The book covers basic SQL queries ...
|
|
The RBU Extension
(rbu.html)
3.1. RBU Vacuum Limitations
When compared with SQLite's built-in VACUUM command, RBU Vacuum has the
following limitations:
It may not be used on a database that contains indexes on expressions.
The database being vacuumed may not be in WAL mode.
|
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... Locking for the newer write-ahead log or WAL mode
is described separately.
1.0 File Locking And Concurrency In SQLite Version 3
SQLite Version 3.0.0 introduced a new locking and journaling
mechanism designed to improve concurrency over ...
|
|
The SQLite OS Interface or "VFS"
(vfs.html)
3.1. Standard Unix VFSes
... Also keeps the wal-index in heap rather than in
shared memory.
unix-none - all file locking operations are no-ops.
unix-namedsem - uses named semaphores for file locking.
VXWorks only.
The various unix VFSes differ only in the way ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... Write the number of pages in the
WAL after the checkpoint into mem[P3+1] and the number of pages
in the WAL that have been checkpointed after the checkpoint
completes into mem[P3+2]. However ...
|
|
Recent SQLite News
(news.html)
... The performance benchmark that
the SQLite developers have used for many years has for
the first time dropped below 1 billion CPU cycles
(measured using cachegrind) when run in WAL mode.
This is less than half the number of CPU ...
|
Page generated by FTS5 in about 37.04 ms.