IRowsetFastLoad

More
6 years 11 months ago #437 by kenn@kero.dk
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
6 years 11 months ago #438 by Moderator
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
4 years 11 months ago #9810 by Moderator
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.137 seconds
Powered by Kunena Forum