How to change Transaction Isolation Level
- From: "Ivan Slavev" <office@xxxxxxxxxxxxxxxx>
- Date: Tue, 4 Jul 2006 09:22:10 +0300
Hi,
I want my application to use the Read uncommited transaction isolation
level, but i can not set it.
If I set the IsolationLevel ot the TADOConnection, this isolation level is
taken into account only when i start a new transaction.
I tried to execute a script after opening the connection like
dbConnection.Execute('SET TRANSACTION ISOLATION LEVEL READ
UNCOMMITTED');
but this did not help as well.
The point is that most of the time the users do just SELECT and I want to
avoid shared locks.
Thanks in advance.
--
Ivan Slavev
General Manager
InnovaSys Ltd.
157 Cherni Vruh blvd.,
1407 Sofia, Bulgaria
mobile: +359 88 666 999 3
e-mail: i.slavev@xxxxxxxxxxxxxxxx
online: www.innovasys-bg.com
Best Regards,
Ivan Slavev
.
- Follow-Ups:
- Re: How to change Transaction Isolation Level
- From: Ralf Jansen
- Re: How to change Transaction Isolation Level
- Prev by Date: Re: Provider cannot be found, It may not be properly installed.
- Next by Date: Re: Provider cannot be found, It may not be properly installed.
- Previous by thread: Re: Problem with TDateTime and ADO
- Next by thread: Re: How to change Transaction Isolation Level
- Index(es):