Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

isolation level

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
hi!

i wrote a little application, that involves a number of clients
and a database-server. the clients query the database, get some
result, then disconnect from the database, do some computation,
then re-connect to the database and write back their results.

my quetsion is: what kind of isolatoin level should i use
(uncommited read, commited read, repeatable read, serializable)?
is there any "thumb-rule" of when to use which isolation level?
what special precautions do i have to take using uncommited read
(for better performance) or repeatable read???

you would help me alot.

thanks in advance,
michael
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top