5. SQL 92
5.4. FrontBase Extensions
Table of Contents
SET TRANSACTION ISOLATION LEVEL VERSIONED;
In addition to the isolation levels defined by SQL 92, FrontBase supports an isolation level called
VERSIONED. This level is ideal for the situation where many users are fetching from the database and where only a few users update the database. Users who only fetch rows will never have to wait for an update to complete. They will, instead, get the data as they existed prior to the start of the update. Once an update has been successfully committed, the updates are available as the next version.
SET TRANSACTIONstatement has also been extended with a locking discipline option:
SET TRANSACTION LOCKING REALISTIC | OPTIMISTIC | PESSIMISTIC;
If you have feedback or questions on this document, please send e-mail to firstname.lastname@example.org. Please reference the section number and topic. Thanks!!
©2000 FrontBase, Inc. All rights reserved.