IRowsetFastLoad

General PGNP discussions.

IRowsetFastLoad

Postby kenn@kero.dk » Wed Sep 29, 2010 2:22 am

Hi

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

--
Rgds. Kenn Roland
kenn@kero.dk
 
Posts: 3
Joined: Fri Sep 24, 2010 2:29 am

Re: IRowsetFastLoad

Postby Moderator » Thu Sep 30, 2010 6:16 pm

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.
User avatar
Moderator
Site Admin
 
Posts: 303
Joined: Wed Oct 29, 2008 11:27 pm

Re: IRowsetFastLoad

Postby Moderator » Wed Oct 17, 2012 11:20 pm

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.
User avatar
Moderator
Site Admin
 
Posts: 303
Joined: Wed Oct 29, 2008 11:27 pm


Return to Miscellaneous

Who is online

Users browsing this forum: No registered users and 2 guests

cron