Your skill will accomplish what the force of many cannot |
|
PerlMonks |
Re: Implementing rowlockingby arkturuz (Curate) |
on Jan 09, 2007 at 09:26 UTC ( [id://593683]=note: print w/replies, xml ) | Need Help?? |
PostgreSQL database server allows locking
data per row. Before you do any coding, maybe you should consider installing it (if you have the permissons to do so). About the algorithm: if I understand correctly, it seems to me that it will not prevent race conditions (because, as you said "the race conditon happens if two http requests manages to check the table before one of them inserts/acquires the lock" but you don't check for it in your algorithm).
In Section
Seekers of Perl Wisdom
|
|