| Description |
Defining the SQL Database Isolation Level (Magic xpa 3.x)
-
From the database entry in the Database repository, select Edit/Properties or press Ctrl+Enter to open the Database Properties dialog box.
-
On the SQL tab of the Database Properties dialog box, enter SQL_ISOLATION_LEVEL=XX in the Database Information window where XX can be:
RR - Repeatable Read
RS - Read Stability
CS - Cursor Stability
UR - Uncommitted Read (It is best to use an Uncommitted Read.)
NC - No Commit
It is recommended to set the Isolation Level in the DBMS Properties dialog box. If you do set the Isolation Level in the Database Properties dialog box, it will override what is set in the DBMS Properties dialog box.
-
Select the Check Existence property.
-
Specify the Array Size number, where the number represents the number of records in a block. Use this option to specify how many records you want to transfer for a single READ request. This parameter may significantly improve I/O performance for sequential READ operations. The default value of 0 returns 20 records in a block.
-
Specify an Alternate Collating Sequence (ACS) file for the specific database.
|
|
|---|
