3 ms·
I have done this, and the one thing I would note is that if you are requesting a maximum number of rows per call, and if something in the queue breaks for all r
by pdntspa 4y ago
I have done this, and the one thing I would note is that if you are requesting a maximum number of rows per call, and if something in the queue breaks for all returned rows (like because it crashed with an exception or something and its status field isnt updated), then you can run a situation where every call to get more rows goes to the same broken rows and the queue becomes blocked. I hadn't figured out a great solution for this but otherwise my SKIP LOCKED queue worked great!