Today, I encountered error Server Error in '/Application Name' Application.
time for stored should be not greater than 1 second only. However in my case the processing
time was 34 sec that's 34 times slower than the ideal time. In displaying details to the users I used the N-tier approach and used stored procedure in querying data. But my stored procedure is too slow, as mentioned in generating 128923 rows it took 34seconds to processed. Increasing the timeout period can temporarily cure the problem but it is not a proactive approach. Instead I make use of temporary tables during run time and scaling my database - proper indexing.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.Ideally in web application when using stored procedure in collating data the processing
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
time for stored should be not greater than 1 second only. However in my case the processing
time was 34 sec that's 34 times slower than the ideal time. In displaying details to the users I used the N-tier approach and used stored procedure in querying data. But my stored procedure is too slow, as mentioned in generating 128923 rows it took 34seconds to processed. Increasing the timeout period can temporarily cure the problem but it is not a proactive approach. Instead I make use of temporary tables during run time and scaling my database - proper indexing.
No comments:
Post a Comment