It is such a
From a remote oracle_remoter, download data to the SQL server.

1, in the local oracle_local with DB Link to download the remote oracle_remoter data very fast, with the Link that the SQL server server transfer to the SQL server, faster,

2, if the SQL server directly from oracle_remoter, is also the link building in the SQL server server, using the same method, but the efficiency is very low, very slow,

What reason be? Thank you very much!

CodePudding user response:

Do dblink between heterogeneous data, is slower than the homogeneous, you how much this time?

PS: do you use SQL server to oracle linkserver, which drive in?

CodePudding user response:

Is a good question,,,,

CodePudding user response:

Driver of the link server is: OraOLEDB. Oracle

Now the main difference is the SQL server using the link from the remote server oracle_remoter download is very slow, but from a local oracle_local is fast, the same table, the difference is the appearance of seven to eight times slower, almost

Remote speed also is not a problem, because the remote oracle_remoter to local oracle_local speed is very, very fast, this is the way in local oracle_local create DB Link,

CodePudding user response:

Haven't met, guess or provide train of thought:
1, in turn, remotely, the efficiency of the oracle used to pull data from the remote,
2, originally also suspect, but the original poster confirmed
3, whether there are differences on the data, such as field similar to match, if there is a process of casting

CodePudding user response:

whether there is something wrong with the Settings

CodePudding user response:

1. Doubt your local and remote table structure is consistent, or according to your description is very should not
2. As you said should be a slow slow in remote, not in essentially, to the remote tracking down what is causing slow