t11a/bulk_insert_sample.rb

## bulk_insert_sample.rb
timestamp = ActiveRecord::Base.connection.quote(Time.now.utc)
inserts = []
10**4.times do |i|
  inserts << "('title#{i}', #{i}, #{i}, #{timestamp}, #{timestamp})"
end
sql = "INSERT INTO books (title, serial, price, created_at, updated_at) VALUES #{ inserts.join(',') }"
Book.connection.execute(sql)
	timestamp = ActiveRecord::Base.connection.quote(Time.now.utc)
	inserts = []
	10**4.times do \|i\|
	inserts << "('title#{i}', #{i}, #{i}, #{timestamp}, #{timestamp})"
	end
	sql = "INSERT INTO books (title, serial, price, created_at, updated_at) VALUES #{ inserts.join(',') }"
	Book.connection.execute(sql)