WebSite Performance decreasing due to more records in gridview

Last Reply on Apr 02, 2012 09:21 AM By Mudassar

Posted on Apr 01, 2012 01:00 AM

Hi,

In my website need to display 5000+ records in gridview. So, I used custom paging for static page bar and displaying 100 records per page. In stored procedure using ROW NUMBER() keyword to retrieve specific records from the database. Even though website is running dead slow. Is there any alternate way apart from the ROW NUMBER() to increase the website performance.  Can anyone please suggest me...It is very critical for me. ...I followed the below article to achive custom paging.

Posted on Apr 02, 2012 09:21 AM

It seems that your code is taking time to execute, hence your AJAX call is failing. You need to optimize your coding

Anyways you can increase the timeout

http://blogs.microsoft.co.il/blogs/aviwortzel/archive/2007/04/16/Sys.WebForms.PageRequestManagerTimeoutException-_2D00_-The-server-request-timed-out-_2D00_-error.aspx

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html