Retrieving more than 1000 data from datatable error mvc4

Question

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

Rajeesh Menoth · Answer

Hi, To work around this issue, use one of the following methods: Set the time-out connection string to the 150 value that sets a time of 150 seconds. When you do this, the data provider waits for 12 seconds to finish the first read call. (The issue does not occur if the call is finished within 12 seconds.) Add the Min Pool Size=20 setting to the connection string. After you add this setting, the data provider maintains at least 20 connections in the data connection pool of the application. Therefore, more opportunities are provided to reuse an existing connection instead of opening a new connection. And when an existing connection is used, you do not receive the error messages that are mentioned in the "Symptoms" section. Note The default value of Min Pool Size is 0. Reference : https://support.microsoft.com/en-us/kb/2605597

Manas Mohapatra · Answer

Then use timeout property or implement paging concept as per my previous answer.

Abhilash J A · Answer

Respected Sir, It is server side timeout

Abhilash J A · Answer

thank you sir for your reply. I will try....

Manas Mohapatra · Answer

Hi Abhilash, You can increase timeout property in jQuery Ajax $.ajax({ url: "test.html", error: function(){ // will fire when timeout is reached }, success: function(){ //do something }, timeout: 3000 // sets timeout to 3 seconds }); Secondly make sure that your server is not getting time out when retrieving from database. Just cross check where it is actually creating problem either in database or server. Lastly I have one suggestion for you to implement paging concept instead of loading 1000 records at a time.