Library Version 18.1.40

Enabling Transaction Snapshots in the SQL Layer
Prev | Chapter 13. Upgrading Berkeley DB 11.2.5.1 applications to Berkeley DB 11.2.5.2 | Next

## Enabling Transaction Snapshots in the SQL Layer

Read/write concurrency can now be enabled in the SQL API by using `PRAGMA multiversion=on` before accessing any tables in the database. After multiversion has been enabled, it can be temporarily disabled using the `PRAGMA transaction_snapshots=on/off`.

### New Pragmas

- `PRAGMA multiversion=ON|OFF;`
- `PRAGMA snapshot_isolation=ON|OFF`

Prev | Up | Next
Heap Access Method | Home | 2SITE_STRICT Enabled by Default in Replication