Execution Timeout Expired. The timeout period elapsed prior to completion of the op

Team,

I have one advanced query in preparation.


I am getting "Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding." in Service center at the time of loading the page , and getting internal error as well on Page.


Can anyone help me how to handle this scenario ?


any help is appreciated.


Thanks,

Sattibabu Vatti.




Hi Sattibabu,

How many records you're trying to select? or how much complex it?
You should consider the performance of your SQL.

Could you try to increase timeout property of your SQL? But of course, It will increase your page loading duration.

With best regards,
F.Karatay

Hi F.Karatay,


Thanks for your reply. 

I am trying to select almost 27 lacks of records and query is simple advanced query. I tried to increase the timeout but its not working.

Please advise.


Thanks,

Sattibabu