sections: performance:performance-immutable-mode

This data as json

id	page	ref	title	content	breadcrumbs	references
performance:performance-immutable-mode	performance	performance-immutable-mode	Immutable mode	If you can be certain that a SQLite database file will not be changed by another process you can tell Datasette to open that file in immutable mode . Doing so will disable all locking and change detection, which can result in improved query performance. This also enables further optimizations relating to HTTP caching, described below. To open a file in immutable mode pass it to the datasette command using the -i option: datasette -i data.db When you open a file in immutable mode like this Datasette will also calculate and cache the row counts for each table in that database when it first starts up, further improving performance.	["Performance and caching"]	[]