[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Nicolás Castagnet

4/3/2002 11:00:00 PM

How pagination is implemented?



I mean, when I make a query with 2124952 registers, where the cursor,
datareader or dataset is stored?



2 Answers

(Simon Calvert)

4/4/2002 7:13:00 PM

0

Durk van Veen

4/5/2002 5:10:00 AM

0

A good way to think about it, is by comparing how the same application would
render on a non-mobile device. If you pulled 2 million records and showed
them all on a single HTML page, it would become huge. All the information
that you would see on this page, gets stored in the view state of the
auto-paginated page. You shouldn't pull down more records than you think you
would display on a non-mobile device (such as Internet Explorer on a
desktop. Implement custom paging in such cases by changing the WHERE clause
on the query.

"Nicolás Castagnet" <ncastagnet@dlya.com.uy> wrote in message
news:eoEz5J12BHA.2048@tkmsftngp05...
> How pagination is implemented?
>
>
>
> I mean, when I make a query with 2124952 registers, where the cursor,
> datareader or dataset is stored?
>
>
>