[drupal-devel] LOCK vs. SELECT FOR UPDATE

Hi there, until now we've largely ignored people who aren't allowed to lock their tables and thus cannot use Drupal. Somebody suggested (http://drupal.org/node/1190#comment-55984) to use SELECT FOR UPDATE in database.mysql.inc instead. Is there any database expert who can comment on the pros and cons of the approach? Cheers, Gerhard