Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Displaying many records on one page
Message
De
21/06/2007 11:28:49
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
21/06/2007 11:26:52
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:
01234738
Vues:
8
>>>>>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
>>>
>>>Yes, I had done research on paging in the past, but using paging doesn't really apply to this situation. Maybe I will just have to use a filter, as that will probably help with another issue I am having.
>>
>>And BTW, if paging, searching, filtering is not an option and you'd fill the page with many records anyway, then directly writing to response buffer via a reader might help (then it would start displaying fast while page continues to fill up).
>>Cetin
>
>Thanks for that tip... I had something like that in the back of my head...

Saying is always easy, isn't it:)
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