Select for update, nowait, skip locked

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.


Comments:

Hi Ram,

Simple and clear illustrations.
Could you also include the concept of MarkReservedValue in distributed polling.
Appreciate your article.

Cheers,
Dev...

Posted by guest on May 24, 2012 at 10:54 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Principal Product Manager

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today