Last post Feb 27, 2011 06:16 PM by Lannie
Feb 27, 2011 12:30 PM|Satya6651|LINK
Hi, I have a doubt. For examples, Multiple users trying to update the same record usign asp.net application.
Can any one explain me indatil the situation how db process the request.?
Feb 27, 2011 06:16 PM|Lannie|LINK
Each database has different technologies for managing conflicts between users.
But most major databases (Oracle, MSSQL) use transient row locking, like first come first served,
and it happens quickly so the next user can update the same row as the second come second served.
In the real world of transactional processing, it is not very often two users will want to operate
an update on the same row in exactly the same instant, so your risk for user conflict is low.
I encorage you to read about optimistic and pessimistic row locking for your database
and how you can control how and when locking is done if you the automatic control is not sufficient for you.