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

[Uri Guttman]

On 05/10/2014 03:12 PM, Michael R. Davis wrote:
> 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,

that would be useful to me if it works on mssql (yes, i have to use it). 
at least the dev work and other systems are linux but the backend db is 
still redmond.

thanx,

uri


-- 
Uri Guttman - The Perl Hunter
The Best Perl Jobs, The Best Perl Hackers
http://PerlHunter.com