Setting the isolation level

Administrator Guide : Performance tuning : Choosing transaction isolation levels : Setting the isolation level

By default, the isolation level in the solidDB^® server is read committed (SQL.IsolationLevel=1). You can also set the isolation level on transaction level or on session-level using SQL commands.

To set the default isolation level, use the SQL.IsolationLevel parameter. The parameter accepts the following values:

▪1 - READ COMMITTED

▪2 - REPEATABLE READ

▪3 - SERIALIZABLE (supported only with disk-based tables)

To set the isolation level for a session, use the following SQL command:

SET ISOLATION LEVEL
{READ COMMITTED | REPEATABLE READ | SERIALIZABLE}

For example:

SET ISOLATION LEVEL REPEATABLE READ

To set the isolation level for a transaction, use the following SQL command:

SET TRANSACTION ISOLATION LEVEL
{READ COMMITTED | REPEATABLE READ | SERIALIZABLE}

For example:

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ