| 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?