[Rails] INSERT INTO 大批資料寫入資料庫

使用方式

直接使用ActiveRecord執行SQL指令

values = users.map { |u| "(#{mass_email.id},#{u.id})" }.join(",")
ActiveRecord::Base.connection.execute("INSERT INTO mass_email_users (mass_email_id, user_id) VALUES #{values}")

參考

1. https://www.joinhandshake.com/engineering/2016/01/26/quickly-inserting-thousands-of-records-in-rails.html