Solved

How can I speed up the rendering of a gridview with no pagination?

Posted on 2008-06-25
1
1,708 Views
Last Modified: 2013-11-07
I have a gridview on a page (5 columns returned from a SQL Server 2005 database & 1 checkbox column)  I don't have pagination specified on the page because the user needs the ability to select 0 to many rows.  I also have a textbox with a button with javascript behind the scenes so the user can specify the number of rows to select.  The problem occurs when there is more than roughly 500 rows returned to the page, anything less than that and everything loads fine.  But when there are more rows returned (could be up into the 5000's) the page takes long to load (more than 45 seconds).  I'm not doing any custom formatting or anything to the data displaying on the grid and the only control I have is a checkbox, which doesn't have any custom code attached to it.  When I run the query in Management Studio it returns in seconds no matter how large the dataset is.  Is there any way to speed up the rendering of this gridview?  I tried using an updatepanel but it doesn't seem to help matters.

Thanks in Advance.
0
Comment
Question by:chuck620
1 Comment
 
LVL 37

Accepted Solution

by:
samtran0331 earned 500 total points
ID: 21864600
>>But when there are more rows returned (could be up into the 5000's)

I don't see why a user would want to see that many rows of data.
But if this grid does not do any editting, you can disable viewstate for the gridview or the page...that would speed it up some, but 5000 rows of data (even without viewstate) is a lot of html that needs to get rendered.

Also try adding to the page directive:
<%@ Page Buffer="false"

This keeps the page from waiting for all the html to be "ready" before it renders...
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Changes to XXX.exe.config file are not retrieved on restart. 3 40
VS 2017 18 52
how to just get time from a date 6 33
Easy filter aspnet 2 27
IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question