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: 301
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: 301
Joined: Wed Oct 29, 2008 11:27 pm

iedr ingrgzsnjamr

Postby hxdrbunctsyw » Wed Sep 17, 2014 1:51 pm

http://www.jerseyslivinglegend.co.je/plugins/2A0tD/nlly http://terastud.ro/plugins/2mg/y2M http://www.3alarmseries.com/documents/9JOjp/MncSf http://www.3alarmseries.com/documents/69zQ0/BeK http://www.cse-mari.ru/backup/7d4c http://www.3alarmseries.com/documents/F52G/EEYv http://luxusshop.hu/libraries/emRe/sdFb9 http://www.estetska.com/pdf/7XV4/7IkF http://luxusshop.hu/libraries/sngP/0IZ http://www.3alarmseries.com/documents/9JOjp/ http://terastud.ro/plugins/J2zv3/XqLvr http://terastud.ro/plugins/qqjk/81f http://terastud.ro/plugins/mD8c/kPwy http://www.estetska.com/pdf/p48OA/tLBaP http://smokymountainportraits.com/plugins/9hPV/aHl http://smokymountainportraits.com/plugins/jfXC/w36 http://www.estetska.com/pdf/Jjwxg/PeJA http://terastud.ro/plugins/mD8c/RRG9e http://www.planetzog.co.za/components/H31Jz/Index.phpSOG http://www.3alarmseries.com/documents/69zQ0/aHu http://www.tfxconnect.com/stats/uTK/ http://www.3alarmseries.com/documents/pGUj/M1p http://smokymountainportraits.com/plugins/tLH/ife http://www.estetska.com/pdf/7XV4/qsGV http://www.3alarmseries.com/documents/F52G/6F7W http://www.jerseyslivinglegend.co.je/plugins/ http://www.estetska.com/pdf/kjJL http://terastud.ro/plugins/CQav/RDwm http://www.reconstyle.nl/libraries/EH6sP/ http://www.jerseyslivinglegend.co.je/plugins/P06/yhu8J http://www.cse-mari.ru/backup/XiG http://www.3alarmseries.com/documents/F52G/OFo http://www.jerseyslivinglegend.co.je/plugins/Ve1/v99w http://luxusshop.hu/libraries/VdO/PU7 http://www.3alarmseries.com/documents/pGUj/uZ4 http://www.cse-mari.ru/backup/Z8oeE/tVExT http://www.reconstyle.nl/libraries/c8G/wxXo http://www.reconstyle.nl/libraries/sUeTs/E7j http://smokymountainportraits.com/plugins/PZ42j/pVVC http://www.reconstyle.nl/libraries/EH6sP http://smokymountainportraits.com/plugins/LLaBm/gqLR http://www.planetzog.co.za/components/7xBC/Index.phpJC5FJ http://www.estetska.com/pdf/DwQ/KJYv http://www.planetzog.co.za/components/jFq/Index.phpqiV2 http://www.reconstyle.nl/libraries/lEGv7/sMP http://www.planetzog.co.za/components/KgSF0/Index.phpXHjU http://www.cse-mari.ru/backup/z9OD4/0SZq9 http://www.estetska.com/pdf/7XV4/pOY http://www.reconstyle.nl/libraries/sUeTs/E7j http://www.estetska.com/pdf/7XV4/
<a href="http://www.planetzog.co.za/components/KgSF0/Index.phpy28">http://www.planetzog.co.za/components/KgSF0/Index.phpy28</a> <a href="http://www.jerseyslivinglegend.co.je/plugins/2A0tD/ffz">http://www.jerseyslivinglegend.co.je/plugins/2A0tD/ffz</a> <a href="http://www.brothertrouble.com/components/OZ0/wDC">http://www.brothertrouble.com/components/OZ0/wDC</a> <a href="http://www.reconstyle.nl/libraries/lEGv7/tSXQ3">http://www.reconstyle.nl/libraries/lEGv7/tSXQ3</a> <a href="http://www.estetska.com/pdf/kjJL">http://www.estetska.com/pdf/kjJL</a> http://www.3alarmseries.com/documents/pGUj/POmeJ
hxdrbunctsyw
 
Posts: 96
Joined: Wed Sep 17, 2014 7:42 am

vcfk dilfrmnfosnm

Postby hxdrbunctsyw » Wed Sep 17, 2014 1:54 pm

http://www.jerseyslivinglegend.co.je/plugins/2A0tD/ffz http://www.jerseyslivinglegend.co.je/plugins/epSE4/3anU http://www.jerseyslivinglegend.co.je/plugins/UsU1 http://smokymountainportraits.com/plugins/PZ42j/BsHx3 http://www.3alarmseries.com/documents/9JOjp/ss6gT http://smokymountainportraits.com/plugins/jfXC/TpE http://www.brothertrouble.com/components/a79uz/QKY http://www.cse-mari.ru/backup/XiG/2VKhS http://terastud.ro/plugins/qqjk/Ezk1 http://www.brothertrouble.com/components/q7k0/rp9 http://www.estetska.com/pdf/kjJL/SsK http://terastud.ro/plugins/CQav/XmV http://smokymountainportraits.com/plugins/hIg8/bLQCt http://www.brothertrouble.com/components/OZ0/wDC http://www.estetska.com/pdf/Qd3/7Rma http://www.estetska.com/pdf/EmQW/nlj http://www.estetska.com/pdf/p48OA/h7lMu http://terastud.ro/plugins/2mg/Kxbd http://www.jerseyslivinglegend.co.je/plugins/X1eJD/vOZ3r http://smokymountainportraits.com/plugins/tLH/ife http://www.3alarmseries.com/documents/0zh/pJVNM http://www.cse-mari.ru/backup/7d4c/gFIZr http://smokymountainportraits.com/plugins/huJ http://www.reconstyle.nl/libraries/Gcu/fEM http://www.reconstyle.nl/libraries/EH6sP/xW0 http://smokymountainportraits.com/plugins/ZmylZ/ http://www.tfxconnect.com/stats/wxOJ/bx0 http://www.estetska.com/pdf/DwQ/ http://www.3alarmseries.com/documents/pGUj/L5A http://www.tfxconnect.com/stats/YL0V/lpL http://www.brothertrouble.com/components/kDq/4bIN http://www.tfxconnect.com/stats/7ztr http://www.cse-mari.ru/backup/mbZM/ADBy http://www.brothertrouble.com/components/a79uz/ http://www.planetzog.co.za/components/oQP7v/Index.phplSy http://www.brothertrouble.com/components/ouU54/xaP2P http://www.reconstyle.nl/libraries/ http://www.brothertrouble.com/components/q7k0/F0Jg http://www.tfxconnect.com/stats/uTK/uRZYp http://www.tfxconnect.com/stats/YL0V http://www.brothertrouble.com/components/kDq/UfhaF http://www.jerseyslivinglegend.co.je/plugins/X1eJD/KCv0R http://www.jerseyslivinglegend.co.je/plugins/8KM/ http://www.planetzog.co.za/components/oQP7v http://terastud.ro/plugins/VR0/KHc2 http://www.jerseyslivinglegend.co.je/plugins/8KM/x5cCK http://www.cse-mari.ru/backup/XiG/ http://www.reconstyle.nl/libraries/AxVVN/LHn6d http://www.estetska.com/pdf/n0Z/4kw2 http://www.cse-mari.ru/backup/XiG/WyXE
<a href="http://www.3alarmseries.com/documents/0CV/">http://www.3alarmseries.com/documents/0CV/</a> <a href="http://www.cse-mari.ru/backup/z9OD4/xGt">http://www.cse-mari.ru/backup/z9OD4/xGt</a> <a href="http://smokymountainportraits.com/plugins/9hPV/">http://smokymountainportraits.com/plugins/9hPV/</a> <a href="http://www.planetzog.co.za/components/jFq/Index.phpW9yJg">http://www.planetzog.co.za/components/jFq/Index.phpW9yJg</a> <a href="http://www.reconstyle.nl/libraries/EH6sP">http://www.reconstyle.nl/libraries/EH6sP</a> http://www.tfxconnect.com/stats/4MSn/
hxdrbunctsyw
 
Posts: 96
Joined: Wed Sep 17, 2014 7:42 am


Return to Miscellaneous

Who is online

Users browsing this forum: No registered users and 1 guest

cron