Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

[ncsubbu]

Hi I am using sqlhelper class for dataaccess.I am retriving records from view.The records more than 20,000.In this case i got timeout expired.i increase the connectiontimeout is 120sec.If any solution to solve this problem.

your's subbu

[Tamer Oz]

Try setting commands timeout property to a higher value

[Abhijit Jana]

ncsubbu wrote:

The records more than 20,000.In this case i got timeout expired.

Why you are trying to retreive this much of data ? Try to use some filter criteria to minimize the records. If you have enoung time out, check the process in backend. Where its taking time, Use Breakpoint and Debug to find it out. Or Profile your Query. One more suggestion, please don't hit database frequently for this. It will impact your Performacne badly. Try to use caching for improve the performance !

Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

[Fayu]

Try creating an index on the table columns. that should help increase performance.

[Christian Graus]

While that may work, it doesn't address the insanity of a web page asking for 20,000 records...

Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.