Michael Peppler wrote:
I've been asked to investigate the feasibility of adding access to
Sybase's bulk-load API in DBD::Sybase. This is an API that allows you to
load table rows in a minimally logged manner, and is of course much
faster than normal INSERT statements.
<snip>
I've built bulk load/unload facilities into DBD::Teradata pretty
much from the outset. Thus far, I use mainly driver-specific
APIs (just to make it easier for end-users, if interested see
www.presicient.com/tdatdbd/tdatdbdfl.html).
In Teradata's case, special connections are required for bulk load/unload,
so there are a few connect() driver-sepcific attributes required.
In addition, Teradata load utilities are intended to handle
multiple terabyte loads, so there are some extra facilities
available to the app (checkpointing, logging, etc.). However,
it is possible for app writers to use the DBI directly
to do the load, so long as they know the right way to connect(),
the right SQL to use, and the proper sequence to execute.
Not certain how useful this is to your case, but figured
I'd pitch my $0.02 in if we're talking about a "standard"
DBI interface for such things. For what its worth, I'd love to see
broader DBD support for such facilities (which is why I kept
pounding the table for array binding), as perl makes a *great*
ECTL tool.
Regards,
Dean Arnold
Presicient Corp.
www.presicient.com
