threads

Queries or sets the suggested number of threads for the background thread pool.

This pragma suggests the number of auxiliary threads that SQLite can use for tasks like sorting large datasets or analyzing indices. The actual number of threads used may be less than this value if they are not needed.

• A positive value N suggests a thread pool of size N.

• A value of 0 (the default) means SQLite will operate in single-threaded mode.

• A negative value means the default number of threads (determined at compile-time) will be used.

This setting is a suggestion and may not be honored if SQLite was compiled with SQLITE_THREADSAFE=0.

See also