3 ms·
But it's the same thing every time. Turn autocommit off, run the SELECT, commit, repeat? Or am I missing something?
by RedShift1 3y ago
But it's the same thing every time. Turn autocommit off, run the SELECT, commit, repeat? Or am I missing something?
- ddorian43 3y agoYou just do the update with skip locked and finish the job until time runs out or update the job "liveness". (can be autocommit on & off)