paging a recordset with many records

[Sonia]

Hi there....

If I use ADO recordset object properites like pagesize and pagecount in order to use for paging the result set --when I am developing a report (for example)
in a web-based appl. , then when a user fetches my report for the first time,
is it true that web server returns all result records to the client and by clicking at "next" link, it shows proper records?

OR

the server returns records as many as i have set it by paging properties even for the first time and when the user clicks on "next" link, then again the web server returns another set of result data?

Whicj one is correct?

Thank you ver much

Sonia

[pclement]

The PageSize and PageCount properties do not limit the number of rows returned from the database. All rows are returned as specified by the SQL statement (or SP) and the web server determines which rows to make available based upon these property settings.

[Sonia]

Paul,
I know that paging a recordset does not limit the number of records return from DB.

but what about web server?is it true that all te result set will not return from
server to client for the first time (by executing the query) and by clicking at "next" link, the web server again returns the proper set of result set to the client.?

[pclement]

Whatever you see in the page is what is being returned to the client. There is no hidden data returned. Only the rows for the logical page are returned to the client browser.

When the user clicks on the next page (or previous page) link, the request is posted to the server and the PageSize and PageCount properties are used to fetch the next set of data to return to the client.

[Sonia]

Paul,

Thanks alot.