Rails updating multiple records in one request?

Question

Ruby on Rails

Hello. There are notifications for users on the site. Notifications have a "read" field. If the user does not enter notifications for a long time, then they accumulate there and when the page is opened, the script sets the field to true one by one. Even about 50 records are processed noticeably. Those. there are about 50 UPDATE queries to the database. Is it possible to bulk apply an attribute?

Answer 1

If possible, use conditional update of records with one query: user.posts.where
(visited: false).update_all(visited: true)
ActiveRecord update_all