tempStore

Queries or sets where temporary tables and indices are stored.

This pragma controls the storage location for temporary database objects (created with CREATE TEMP TABLE).

The value is a TempStore enum, which corresponds to the following modes:

• TempStore.DEFAULT (0): The compile-time default is used, which is typically FILE.

• TempStore.FILE (1): Temporary tables are stored in a separate temporary file on disk.

• TempStore.MEMORY (2): Temporary tables are stored in main memory. This is faster but consumes more RAM and the data is lost if the application crashes.

This setting can be changed at any time, but it only affects temporary tables created after the change. Existing temporary tables remain where they were created.

See also