Rails create single record VS create multiple records PERFOMANCE difference

Question

Is there speed difference between this methods? (POSTGRESQL)

First

products = [{...},{...},...]
products.each { |p|
  Product.create(p)
}

Second

products = [{...},{...},...]
Product.create(products)

Both methods for each record make two queries:

1) INSERT INTO "products" VALUES (..)
2) UPDATE "products" SET "updated_at"...

Answer 1

max is right: both queries are the same, and you can write custom SQL. This is only a local solution though.

But I've found activerecord-import gem that is doing the same – bulk objects import.

products = [{...},{...},...]
Product.import(products)