currently i am facing one problem in my application. This application uses the a store procedure (its dynamic store procedure), when this SP is executed from SQL Studio it executes in 3-4 secs but when the same SP executed through application its getting
time out. It really surprising to this behaviour. I ran the SQL profiler as well. more over this, does execute for different parameters and returns the data.
FYI: After click on one of the link in application this SP gets executed get the data into Dataset and later this dataaset is being used to transform into Excel. But before it goes into all this, it gives the timeout error while executing the SP.
another point here is this SP does have lots of joins and also refering to View. I have also tried to use the Index view but it is not possible as my view also has the outer join.
Please let me know what you guys thing about this.
Thanks in advance
View Complete Post