Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Displaying many records on one page
Message
De
21/06/2007 11:15:18
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
21/06/2007 09:37:12
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
Environment:
ASP.NET
Divers
Thread ID:
01234667
Message ID:
01234724
Vues:
9
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform