WebSite Performance decreasing due to more records in gridview

Custom paging using RowNumber is the only solution at the moment and it is quite effecient.

1. I would suggest check your stored procedure execution time in database and see if there is some optimization needed in your query

thanks....let me try ur solution.......

Hi,

On local system it is working fine but it is taking time to load the gridview without any error. When I hosted application on server, i am getting the following error. I am using the ajax update panel. I executed the queries on database...the results are retrieving in 00:00:00 seconds.

Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 0

Sys.WebForms.PageRequestManagerTimeoutException: The server request timed out.

Can anyone help me how to fix the above issues......???

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