Re: Array load from remote site through Perl/DBI

Gauthier, Dave wrote:
> I have a perl/dbi app that loads my DB with sequential and discrete
> insert statements.  Runs very fast and I’m satisfied with it.  Now I
> have to run the same app from a different site, but loading my local
> DB.  The “one at a time” inserts take too long, probably because of the
> client/server delays incurred with the remote DB attach.
>
> I was thinking of pooling all the data for the insert into arrays and
> then doing a single array insert, therby cutting down on all the
> back/forth.  But there may be other approaches.

I suggest using COPY instead of INSERT, if all you're doing is adding
bulk data to a database.

> Again, Perl/DBI, remote attach, Running v8.2.0 on Linux

Version 8.2.6 is the latest release in the 8.2 branch.  You really
shouldn't be running 8.2.0 anymore.

Colin