How to set transaction isolation levels?

Transaction isolation level is an important factor that affects the performance of a database application. To prevent erroneous user input, you must enter or locate the path to your Transaction Prototypes File through Experiment Setup Window before you are allowed to set transaction isolation levels.

To set isolation levels for different transactions, first click Edit on the menu bar, then choose Set Isolation Levels. Or, click the  icon on the tool bar. A Set Transaction Isolation Levels window shall be displayed:

(You may also open this window by clicking the Set Isolation Level button in Experiment Setup panel of an Experiment window. )

The default isolation level for each transaction is level 1, Transaction Read Committed.  To change levels for any of your transaction, please use one of the selection modes below:

   Single Selection Mode

To set isolation level for a transaction, first highlight the transaction from Preview Table, then select your desired isolation level from the Available Transaction Isolation Levels list, click Set Level. You shall see that the isolation level for that transaction is changed in the preview table. Click Apply to confirm your changes, or click Cancel to abandon all your changes.

   Multi Selection Mode

You may also set one isolation level for a group of transactions in one snap! First highlight all the transactions whose level you would like to change from the preview table, then select the desired isolation level from the Available Transaction Isolation Levels list, click the Set Level button. You shall see that the isolation levels for those transactions are changed in the preview table. Click the Apply button to confirm your changes, or click the Cancel button to abandon all your changes.

   Set Isolation Levels back to Default

If you need to abandon all your changes and set isolation levels back to default for all transactions, click Default button, then click the Apply button to confirm your changes.
 
 

Back to Help Contents