Retrieving more than 1000 data from datatable error mvc4

Abhilash J A

10y896Visual Basic .NET

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth10y ago
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
+1
Manas Mohapatra10y ago
Then use timeout property or implement paging concept as per my previous answer.
0
Abhilash J A10y ago
Respected Sir,
It is server side timeout
0
Abhilash J A10y ago
thank you sir for your reply. I will try....
0
Manas Mohapatra10y ago
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.
0