Last post Sep 13, 2019 02:26 PM by KathyW
Sep 13, 2019 12:43 PM|kashifdotnet|LINK
I am maintaining a large ASP.NET 4.0 and ADO.NET application written by another developer. The application has many pages with GridView and the performance is painfully slow. The pages make use of pagination but user can view complete data (upto 10k records)
at a time. The ADO.NET queries are efficient enough and return the data in less than a millisecond. I have tried many options including:
However, the performance has not improved much. The HTML rendering of the pages is very slow due to large page size (around 10-12 MB). Following is a sample code used for data binding:
private void Bind (int param, int param)
list= new CarBLL().Get_Car_List (param1, param2); // data return in ms
if (list.count > 0)
grid.DataSource = list;
Can some one help me in this regard. Thanks in advance.
Sep 13, 2019 12:56 PM|mgebhard|LINK
User's cannot comprehend or work with 10k records on the computer screen. The logical solution is to limit the records. Rather than fetching all records only fetch one page at a time. Perhaps cache the each page that's request to speed up fetching pages
that have already been read.
Sep 13, 2019 02:26 PM|KathyW|LINK
Limit the amount of data users can see. A web page was never supposed to render thousands of lines. Users can't possibly view/scan 10K lines, either. Give them a way to filter/search the data, and only fetch and download the results of the filter/search
from the server; don't download everything and then filter/search.