![]() |
Cloudscape Properties
|
Reference Manual |
cloudscape.locks.escalationThresholdFunctionSets the threshold at which the optimizer (during compilation) escalates the locking on a table from row level to table level for a statement. If the optimizer estimates that executing the statement will lock more rows in a table than the number specified in this property, the optimizer locks the entire table instead and releases the row-level locks. Also used by the Cloudscape system at runtime in determining when to attempt to escalate locking for at least one of the tables involved in a transaction from row-level locking to table-level locking. This runtime decision is independent of any compilation decision. A large number of row locks use a lot of resources. If nearly all the rows are locked, it may be worth the slight decrease in concurrency to lock the entire table to avoid the large number of row locks. For more information, see Locking and Performance. It is useful to increase this value for large systems (such as enterprise-level servers, where there is more than 64 MB of memory), and to decrease it for very small systems (such as palmtops). Syntaxcloudscape.locks.escalationThreshold=numberOfLocks DefaultMinimumMaximumExample-- system-wide property
-- database-wide property
-- publishing a database-wide property Scopedatabase-wide (publishable) Dynamic or StaticDynamic; the change takes effect immediately. For information about dynamic changes to properties, see Dynamic or Static Changes to Properties. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |