Home
|
Previous Page
|
Next Page
Programming for a Multiuser Environment
In This Chapter
Concurrency and Performance
Locking and Integrity
Locking and Performance
Concurrency Issues
How Locks Work
Kinds of Locks
Lock Scope
Database Locks
Table Locks
Row and Key Locks
Page Locks
Coarse Index Locks
Smart-Large-Object Locks (IDS)
Duration of a Lock
Locks While Modifying
Locking with the SELECT Statement
Setting the Isolation Level
Comparing SET TRANSACTION with SET ISOLATION
ANSI Read Uncommitted and Informix Dirty Read Isolation
ANSI Read Committed and Informix Committed Read Isolation
Informix Cursor Stability Isolation
ANSI Serializable, ANSI Repeatable Read, and Informix Repeatable Read Isolation
Update Cursors
Retaining Update Locks
Locks Placed with INSERT, UPDATE, and DELETE
Understanding the Behavior of the Lock Types
Controlling Data Modification with Access Modes
Setting the Lock Mode
Waiting for Locks
Not Waiting for Locks
Waiting a Limited Time
Handling a Deadlock
Handling External Deadlock
Simple Concurrency
Hold Cursors
Using the SQL Statement Cache
Summary
Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]