i have an application in VB.net which retieves about 1 million records. all this time it worked fine. but today when i tried to retrieve the information i got a sql timeout. wt can i do to avoid this??
Shanika, ..Yes...I face the same issue before..Hmm I can understand your issue with Millon recordset. Yes, there is a way, You can increase your period time from frontend (.config file)... Lets say, if you have timeout period is only 30 seconds you can make now more 30 sec. means 60 seconds. hope it will solve your problems. Thanks, Sandy.
thank you sandy for your reply when you say config file do u mean the vb.net config file?? i'm a bit confused??
Shanika, Its very simple.Just open your application (Vb.net).Then apply it.. I mean to say....If you open your application you willl find a Config file in that (Solution Explorer) .. open it in any editor and change the timeout seconds... and again run the application and check it.... Thanks, Sandy.
1 million records, what kind of queries you are executing from VB application to SQL database? If you are getting timeout see whether it is a lock timeout or general connection timeout from database end. I wouldn't recommend to increase the timeout value on fly without looking the underlying factors such as fragmentation on tables, network issues from client to server (vice-versa) and any other processes on SQL Server at this time.
