Home -> Mailing Lists -> Oracle-L -> Inserts over dblink

Inserts over dblink

From: Steve T. Baldwin <stbaldwin_at_multiservice.com>
Date: Mon, 19 Jun 2017 00:10:20 +0000
Message-ID: <BY2PR0101MB0887ADB6433F74BFBC84DEE5DDC40_at_BY2PR0101MB0887.prod.exchangelabs.com> 





Hi,




I've not used DB Links much so this may be a naive question but can someone help me understand why:




insert into remote_table_at_dblink select from local_table (approx 30 seconds for 1000 rows)




would be ~ 100x slower than:




insert into local_table select from remote_table_at_dblink (approx 0.3 seconds for 1000 rows)




Thanks,



Steve





This email is intended solely for the use of the
addressee and may contain information that is
confidential, proprietary, or both. If you receive
this email in error please immediately notify
the sender and delete the email.




--
http://www.freelists.org/webpage/oracle-l


Received on Mon Jun 19 2017 - 02:10:20 CEST












Original text of this message