Name

default_cache_size — Set default size of page cache for this database

Common Usage

PRAGMA [database.]default_cache_size;
PRAGMA [database.]default_cache_size = pages;

Description

The default_cache_size pragma controls default cache size for a given database. The pages value is stored in the database file, allowing this value to persist across database connections. The default cache size may be temporarily overridden using the cache_size pragma. Setting this value also sets the limit on the current page cache.

See Also

cache_size, page_size

Get Using SQLite now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial