Array load from remote site through Perl/DBI
От | Gauthier, Dave |
---|---|
Тема | Array load from remote site through Perl/DBI |
Дата | |
Msg-id | 0836165E8EE50F40A3DD8F0D8713726718625E@azsmsx421.amr.corp.intel.com обсуждение исходный текст |
Ответы |
Re: Array load from remote site through Perl/DBI
Re: Array load from remote site through Perl/DBI Re: Array load from remote site through Perl/DBI |
Список | pgsql-general |
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.
Again, Perl/DBI, remote attach, Running v8.2.0 on Linux
Thanks
-dave
В списке pgsql-general по дате отправления: