Select for update, nowait, skip locked

Posted by: on Mar 28, 2012 | No Comments

Our DB Adapter uses Skip locking to enable distributed polling - one of the ways to scale up your inbound db processing. I thought I would illustrate at a very high level how select for updates in general, and skip locking work.