readUncommitted

Queries or sets the read_uncommitted isolation level.

When enabled (true), this connection is allowed to read from tables that are concurrently being written to by other connections ("dirty reads"). This can improve performance by reducing lock contention, but it may result in reading data that is later rolled back, leading to inconsistent or transient views of the data.

When disabled (false, the default), the connection will adhere to the standard isolation levels, blocking until a write transaction is complete before reading from the affected tables.

This pragma has no effect if the database is in write-ahead logging (journalMode = WAL) mode, as WAL mode allows readers and writers to operate concurrently without blocking each other.

See also