[pm-h] DBI Bulk Inserts and Updates

Todd Rinaldo todd at rinaldo.us
Wed Apr 16 17:18:21 PDT 2014


DBD and portable aren't really synonymous. Each of those will have a
slightly different interface which may offer enhanced performance you
wouldn't get from using a generic method. Can you provide code
snippets or an example of what you're trying to do?

On Wed, Apr 16, 2014 at 5:38 PM, Michael R. Davis <mrdvt92 at yahoo.com> wrote:
> Perl folks,
> I'm having performance issues with one of my scripts. Our DBA would like for me to investigate bulk inserts.  I see all of the array tupple fetch stuff but don't really get the API.  Are there examples out there where someone has a working example.  What I have is my data in a list of array references and I just want to insert in one batch.  We use Oracle, MySQL and PostgreSQL so a portable version would be best.
> Mike
> _______________________________________________
> Houston mailing list
> Houston at pm.org
> http://mail.pm.org/mailman/listinfo/houston
> Website: http://houston.pm.org/



-- 
Todd Rinaldo
todd at rinaldo.us


More information about the Houston mailing list