Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Displaying many records on one page
Message
From
21/06/2007 11:15:18
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
21/06/2007 09:37:12
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
ASP.NET
Miscellaneous
Thread ID:
01234667
Message ID:
01234724
Views:
10
>I am trying to create a page of historic records, so there are going to be like 10,000 records that will be displayed on this page in a GridView. The page is taking a little over a minute to load. The data is taking about 20 seconds to load, but the page is taking the rest of the 40-50 seconds. Is there a way to speed this up? I think 20-30 seconds would be an acceptable time to wait for the amount of data showing, but the 40-50 seconds in unacceptable. Is it the GridView that is taking forever to load?

Mike,
With a lot of data it's better to introduce paging both in datasource and on page itself. With SQL server for example you can use rowcount to limit records fetched. PageIndex and PageSize parameters sent to a stored procedure tells the procedure where to start and when to stop. Unfortunately otherwise .net is not yet clever enough to determine your intention.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform