Save 36% for Black Friday! Learn more

New Discussion

Notifications

You’re not receiving notifications from this thread.

Transactions

2
Databases

If I am working on a db with millions of users and i have a job that requires updating multiple tables, what is the best way to approach this? I was thinking to wrap it in a transaction but the issue with that is it locks and can cause deadlocks if the transaction is slow. Another possibility is making the job idempotent. any advice?

Join the discussion
Create an account Log in