New answers tagged


"Read chunks, but only update a few of them"... SELECT a chunk -- separate transaction, don't care about locking, etc munch on that chunk to figure out the 'few' ids to update BEGIN; SELECT ... WHERE id IN (list of the few) FOR UPDATE; minimal other work UPDATE them; COMMIT; -- plus checks for deadlocks, etc, and restart the code. The idea ...

Top 50 recent answers are included