October 14, 2009 at 10:00 am
Hello @ all,
could you tell me which is the fastest way to write data from SQL Server 64 Bit to Oracle.
We installed the Oracle Client and set up a Linked Server with "Oracle provide for OLE DB" Provider and it takes 20 Seconfs for 200 rows.
That's so slow. Any ideas?
Thanks a lot!
October 16, 2009 at 8:13 am
is Oracle server local or remote?
how many network hops?
bandwith?
latency?
how complex is the query reading from SQL Server?
post offending query execution plan.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.October 16, 2009 at 9:26 am
is Oracle server local or remote?
- remote (Sql Server Europe, Oracle US)
how many network hops?
bandwith?
- T1 = 1,544 Mbit/sec.
latency?
- 200ms
how complex is the query reading from SQL Server?
- very simple, insert * into target Select * from source
post offending query execution plan.
- is not necessary i think?
Thanks a lot!
October 19, 2009 at 3:44 am
Here the remaining information:
Network Hops:
8
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply