IRowsetFastLoad

More
7 years 7 months ago #437 by kenn@kero.dk
kenn@kero.dk created the topic: IRowsetFastLoad
Hi

Does PGNP support IRowsetFastLoad. if not how is bulk insert performed using OleDB

--
Rgds. Kenn Roland

Please Log in or Create an account to join the conversation.

More
7 years 7 months ago #438 by Moderator
Moderator replied the topic: Re: IRowsetFastLoad
No, version 1.3 does not support IRowsetFastLoad. We may add the support in 1.4 and already have a proof of concept.
However, the bulk insert is supported. You can use BULK_METHOD/BULK_INSERT parameters of connection string for fast data load. The Bulk Insert is enabled in Data Link dialog's Advanced page (see Bulk Insert Method=Copy, and Bulk Insert Buffer Size=1000).

Bulk Insert can be used in a Linked Server via Extended Properties of the connection string, e.g.: BULK_METHOD=COPY;BULK_INSERT=1000;

Greenplum/EMC edition of the PGNP Provider supports gpload/gpfdist mode that has even higher performance than COPY due to utilization of multiple Ethernet cards.

For more information see Developer Manual, the section describing connection string.

Please Log in or Create an account to join the conversation.

More
5 years 7 months ago #9810 by Moderator
Moderator replied the topic: Re: IRowsetFastLoad
Version 1.4.0.3076 SE, and later, supports RowsetFastLoad. "PGNP with BI Alias" should be used in SSIS. Please read Developer's Manual for more information.

Please Log in or Create an account to join the conversation.

Time to create page: 0.140 seconds
Powered by Kunena Forum