Skip Menu |
 

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

Report information
The Basics
Id: 105919
Status: new
Priority: 0/
Queue: DBD-Pg

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

Bug Information
Severity: Wishlist
Broken in: (no value)
Fixed in: (no value)



Subject: Add multiple row inserts to execute_array?
Download (untitled) / with headers
text/plain 415b
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 is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

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