This queue is for tickets about the DBD-Pg CPAN distribution.

Report information
The Basics
Id:
105919
Status:
new
Priority:
Low/Low
Queue:

People
Owner:
Nobody in particular
Requestors:
jmitchell [...] frb.gov
Cc:
AdminCc:

BugTracker
Severity:
Wishlist
Broken in:
(no value)
Fixed in:
(no value)



Subject: Add multiple row inserts to execute_array?
While exploring how to speed up bulk inserts, I discovered that (from the psql command line) multiple inserts (e.g. "insert into foo (id) values (1), (2), (3), ... (n);") are MUCH faster (286 times faster according to my simple test where n=10,000) than the next best option (begin, prepare, execute n times, deallocate, commit). Would it be possible for DBD::Pg's execute_array() to do multiple inserts similarly?


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.