An Asynchronous I/O Module For SQLite

An Asynchronous I/O Module For SQLite

NOTE: 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 module is no longer supported- The source code continues to exist in the SQLite source tree, but it is not a part of any standard build and is no longer maintained- This documentation is retained for historical reference-

Normally, when SQLite writes to a database file, it waits until the write operation is finished before returning control to the calling application- Since writing to the file-system is usually very slow compared with CPU bound operations, this can be a performance bottleneck- T