Hey Guys,
If you are facing the problem of connection time out, there might be following issues:
1.You are using query instead of using procedure (Avoid using direct query).
2.You are using your page in debug mode = true (Set it to false) when not in development mode.
3.Don not try to open and close connection every time.
4.Do not use select * (use only particular fields which you need) it will also prevent your time out issue.
5.Try to maximize your connection time out in conection string (web.config).
6.Try to set Command Time out.
7.Last but not least check your log files of server (might be fulled) and try to clear it but be sure you have all the back up files (db, .mdf, .ldf).
I think above points will save your time.
If you are facing the problem of connection time out, there might be following issues:
1.You are using query instead of using procedure (Avoid using direct query).
2.You are using your page in debug mode = true (Set it to false) when not in development mode.
3.Don not try to open and close connection every time.
4.Do not use select * (use only particular fields which you need) it will also prevent your time out issue.
5.Try to maximize your connection time out in conection string (web.config).
6.Try to set Command Time out.
7.Last but not least check your log files of server (might be fulled) and try to clear it but be sure you have all the back up files (db, .mdf, .ldf).
I think above points will save your time.
Comments