Two new Berkeley DB SQL API specific pragmas have been added,
bdbsql_shared_resources
and
bdbsql_set_lock_tablesize
.
bdbsql_shared_resources
is used to set the maximum
amount of memory, in bytes, to be used by shared structures in the main
environment region, which is useful in applications with a large
number of tables, transactions, or threads.
bdbsql_set_lock_tablesize
is used to set the number
of buckets in the lock object hash table in the Berkeley DB
environment, which is useful if an application has many concurrent
long running transactions.