G
Guest
Hi there,
Though these are some questions on isolation, i dont find good article
clearing
my doubts before i put some transaction stuff in production.
Trans-> Required. Isolation->Read committed. I am inserting new records /
updating an existing record through this trans.
Why I m not able to query other records through select stmnt from sql
server. Always holds and releases whole table only after my trans over.
Records i m trying to select are those which are not affected by my
transaction. This way, whole table will get stucked in production. Coz, this
table will be accessed for diff processes. Please clarify.
Or which is the best way to do ?
Raf.
Though these are some questions on isolation, i dont find good article
clearing
my doubts before i put some transaction stuff in production.
Trans-> Required. Isolation->Read committed. I am inserting new records /
updating an existing record through this trans.
Why I m not able to query other records through select stmnt from sql
server. Always holds and releases whole table only after my trans over.
Records i m trying to select are those which are not affected by my
transaction. This way, whole table will get stucked in production. Coz, this
table will be accessed for diff processes. Please clarify.
Or which is the best way to do ?
Raf.