Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see How to Migrate to InterSystems IRIS, available on the WRC Distributions page (login required).

LockThreshold

SQL lock threshold.

Synopsis

[SQL]    LockThreshold=n

Description

The value n is the lock threshold. This is the number of inserts, updates, or deletes for a single table within a single transaction that will trigger a table-level lock when reached. For example, if the lock threshold is 1000 and a process starts a transaction and then inserts 2000 rows, after the 1001st row is inserted the process will attempt to acquire a table-level lock instead of continue to lock individual rows. This is to help keep the lock table from becoming too full.

Examples

LockThreshold=1000

Range of Values

Any integer. The default is 1000.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, in the Lock Threshold field, enter a number.

Feedback