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

New Pragmas

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