Speed up bulk insert operation

product.rb

require 'activerecord-import'

class Product < ActiveRecord::Base

  has_many :product_keywords, dependent: :delete_all

  def update_product_keywords
    self.product_keywords.delete_all
    records = []
    title_keywords.each do |keyword|
      records << product_keywords.new(brand_id: brand_id, category_id: category_id, value: keyword)
    end
    ProductKeyword.import records
  end
end

products.thor

# second example runs 6 times faster

Product.where("updated_at > ?", 1.hour.ago).each do |product|
  product.update_product_keywords
end

ActiveRecord::Base.transaction do
  Product.where("updated_at > ?", 1.hour.ago).each do |product|
    product.update_product_keywords
  end
end

  

Yay Ruby!!

You are scaring me with these finds.