database locking

[Sarath Koiloth Ramath]

Hi friends,

I have 3 clients which is updating my database,these three cleints is changing the data in the database at the same time.i want to to solve make the updation one by one with out using the thread mechanism(like synchronization ).

can anyone help me to solve this issue

[Scott Selikoff]

Why not manage the information using an in-memory cache, which periodically dumps to the database? If you really want all 3 to have simultaneous access, database ACID principles are probably going to cause some users to get stale data exceptions. Alternatively, you could catch stale data exceptions and transparently refresh the user's data.

[Jelle Klap]

It depends on the system in question, but generally speaking there are two way to go: an optimistic locking strategy or a pessimistic locking strategy.
You'll need to determine if collisions are expected to occur frequently in your multi-user system and what's an acceptable way of dealing with them when they do. The first strategy seems like the most obvious candidate for a foolproof solution, but a pessimistic approach risks compromising the performance of the system as a whole, which is something to be wary of.