Re: Concurrency control in web applications

Under MySQL, you can use InnoDB tables, which support row-level locking. See http://www.innodb.com/ibman.html#Locking_reads. I'm sure other databases support this, too.

----
I wanted to explore how Perl's closures can be manipulated, and ended up creating an object system by accident.
-- Schemer

:(){ :|:&};:

Note: All code is untested, unless otherwise stated

Comment on Re: Concurrency control in web applications Download Code

Replies are listed 'Best First'.
Re: Re: Concurrency control in web applications by perrin (Chancellor) on Oct 24, 2003 at 20:30 UTC
In a web application this is no help. You can't just lock the rows whenever you send out an editing form, because when the user submits that form the request might go to a totally different server process, or the user might simply shut down their browser and leave the rows locked forever.	[reply]

In Section Meditations