ASP/MS Access paging through large recordset

I have a 7000 record set in MS Access on a fast server.
Broadband connection.
Takes quite a bit of time to pull the recordset down to a browser.
Makes sense.
So... I set up paging and it still seems like it is reading the entire
recordset just to display page 1 or page 2 or whatever.
I've tried turning buffering on/off.
I've tried changing the CursorType and CursorLocation.
Am I spinning my wheels?
Please help.

--
Scotter

Re: ASP/MS Access paging through large recordset

Scotter wrote:
> I have a 7000 record set in MS Access on a fast server.
> Broadband connection.
> Takes quite a bit of time to pull the recordset down to a browser.
> Makes sense.
> So... I set up paging and it still seems like it is reading the entire
> recordset just to display page 1 or page 2 or whatever.
> I've tried turning buffering on/off.
> I've tried changing the CursorType and CursorLocation.
> Am I spinning my wheels?
> Please help.

We've pointed you at aspfaq before. Have you checked there? I'm pretty sure
there's an article there about recordset paging. I also think Ken Shaeffer
has one on his site www.adopenstatic.com

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: ASP/MS Access paging through large recordset

Hi Scotter,

Here are some other articles discussing on recordset paging in asp:

#ADO Recordset Paging in ASP
http://www.codeproject.com/asp/rspaging.asp

http://forums.aspfree.com/archive/t-20946

http://www.codefixer.com/codesnippets/recordsetpaging.asp


Hope also helps. Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Re: ASP/MS Access paging through large recordset

Steve,

Could Microsoft provide, via a Service pack, ability to specify the paging
in SQL query itself? I think you can do such a thing in mySQL. And given
that it is the most request feature, I wonder why MS did not provide this.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com


"Steven Cheng[MSFT]" wrote in message
news:RY378IwyEHA.2544@cpmsftngxa10.phx.gbl...
> Hi Scotter,
>
> Here are some other articles discussing on recordset paging in asp:
>
> #ADO Recordset Paging in ASP
> http://www.codeproject.com/asp/rspaging.asp
>
> http://forums.aspfree.com/archive/t-20946
>
> http://www.codefixer.com/codesnippets/recordsetpaging.asp
>
>
> Hope also helps. Thanks.
>
> Regards,
>
> Steven Cheng
> Microsoft Online Support
>
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>

Re: ASP/MS Access paging through large recordset

Thanks for your followup Manohar,

As for the database record paging, it is a common requirement when we
display database driven web pages. And there are also different means to
implement paging. Some do paging in the front UI layer, some in business
logic layer and the others in database layer. And in database layer,
there're also different approaches such as using sub querys or using a
indexable primary key column. We can choose any of them to do paging in our
web application, and not every means can be encapsulated as an internal
part of the SQL db, that'll make the developer more free to make use any
one they prefere. Here is a kb artcle discussing on using stored procedure
to do large result paging in SQL Server:

#How to dynamically page through a large result set in ASP.NET by using SQL
Server stored procedures in Visual C# .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;8291 42

Hope also helps. Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Re: ASP/MS Access paging through large recordset

> So... I set up paging and it still seems like it is reading the entire
> recordset just to display page 1 or page 2 or whatever.
> I've tried turning buffering on/off.
> I've tried changing the CursorType and CursorLocation.

http://www.aspfaq.com/2120

Re: ASP/MS Access paging through large recordset

> Could Microsoft provide, via a Service pack, ability to specify the paging
> in SQL query itself?

Yukon is going to offer a new feature called ROW_NUMBER() which will allow
you to do this in the query.

However, in my testing so far, it doesn't beat the fastest performers in
http://www.aspfaq.com/2120 ... maybe it will get better as we get closer to
RTM; after Beta 3 is out I will post an update to that article that includes
techniques in Yukon...

A