All threads / Transactions
Ask A Question

Notifications

You’re not receiving notifications from this thread.

Transactions

Jacob Abraham asked in 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

Want to stay up-to-date with Ruby on Rails?

Join 60,968+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.

    logo Created with Sketch.

    Screencast tutorials to help you learn Ruby on Rails, Javascript, Hotwire, Turbo, Stimulus.js, PostgreSQL, MySQL, Ubuntu, and more. Icons by Icons8

    © 2022 GoRails, LLC. All rights reserved.