Long SQL operation - Any Expert ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello , All My problem is like that I m fetching data from Remote Databse
Server . The data that i want retreive is so large that it take too much
time, and system shows me error like Time Out expires. I have putted
Timeout=0 . I have also tried timeout=120 . But Problem as it is . So any
Expert Please help Me.
 
Did you set the CommandTimeout property?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
There are a few things you should consider

1) Is the procedure that is called to fetch the data optimised in any way

2) Are the Indexes on any / all of the tables setup correctly

3) is it possible to retrieve the data over many smaller calls rather one big call

4) what format is your result type (dataset / XML) as dataset works better with larger result sets ..

Once you have checked all these things out, and you have it running as fast as you expect it then go back to the timeout settings on your command object !!!!
 
Back
Top