I&#039ve implemented paging using the code on your this site, in the article "Paging through recordsets n records at a time." I got the impression from that article and from others I&#039ve read that I would only be transferring one page&#039s worth of records (or keys) between the SQL server and the web server.<BR><BR>I tested this with a large table, and I&#039m transferring 6MB, regardless of whether I&#039m getting the first page or the last!<BR><BR>If I move the cursor location to the server, I transfer only a few bytes, but the query time is still pretty long.<BR><BR>Paging is neat, but might it be more efficent to use:<BR>select top 10 * from Table where Index &#062; LastIndex,<BR>etc.?<BR><BR>Thanks,<BR>Jim