Locking bugs temporarily?

[Eric Olson]

> I don't like hard locks such as what you get with SELECT ... FOR UPDATE
> because they're better for database integrity than for mutual exclusion.

I'm not sure I get why the application lock is preferred over the SELECT FOR UPDATE lock. It seems to me that method has several disadvantages. Since you're presumably obtaining a lock on the database row anyway (though maybe implicitly when you do an update), why not just use that mechanism?
_______________________________________________
dev-apps-bugzilla mailing list
dev-apps-bugzilla at lists.mozilla.org
https://lists.mozilla.org/listinfo/dev-apps-bugzilla