SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Query Oracle Linked Server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

infodemers
Posting Yak Master

Canada
181 Posts

Posted - 07/08/2013 :  13:24:40  Show Profile  Reply with Quote
I run a query using an Oracle Linked Server.

This seems to run forever.
SELECT * FROM LinkedServer..Schema.View WHERE TN= '2034561295'

...and any other field in the where clause work fine.
SELECT * FROM LinkedServer..Schema.View WHERE SPID= '8088'

Weird isn't!

James K
Flowing Fount of Yak Knowledge

3557 Posts

Posted - 07/08/2013 :  13:43:40  Show Profile  Reply with Quote
How a query performs depends very much on the filtering conditions, such as you have in the WHERE clause here. It just may be that the first query is taking too long because the where clause is not selective enough. If you have access to te Oracle Server you can run the same query on it directly and see how many rows it returns and how long it takes to see if the problem is replicated there.
Go to Top of Page

infodemers
Posting Yak Master

Canada
181 Posts

Posted - 07/08/2013 :  14:07:33  Show Profile  Reply with Quote
On the Oracle server side, it takes like less than one second..
Go to Top of Page

infodemers
Posting Yak Master

Canada
181 Posts

Posted - 07/10/2013 :  10:31:51  Show Profile  Reply with Quote
I finally decided to give up using a linked server to an Oracle DB since it takes too long to get a result.
I believe it is not the appropriate thing to do when the table in Oracle DB is too huge.
Using a ADO.NET connection type within a Visual Studio ASP.net project, works perfectly fine.

Regards!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000