[pm-h] Bulk Inserts in DBIx::Array

Michael R. Davis mrdvt92 at yahoo.com
Sat May 10 12:12:12 PDT 2014


Perl Folks,
I finally figured out the Bulk Insert capability of DBI and I have wrapped it up in my DBIx::Array object.  Take a look let me know if you find it interesting or useful.  http://search.cpan.org/perldoc?DBIx%3A%3AArray

My tests on Oracle show that bulk inserts are much faster going from 0 at 1 row to 100 times faster at 10,000 records.

Inserts for 50,000 records in 3 seconds is quite impressive.
Thanks,
Mike
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/houston/attachments/20140510/f76e9891/attachment.html>


More information about the Houston mailing list