Re: ASP/MS Access paging through large recordset

From: Steven Cheng[MSFT] (v-schang_at_online.microsoft.com)
Date: 11/16/04 

Date: Tue, 16 Nov 2004 05:43:28 GMT

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;829142

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.)

Relevant Pages

  • Re: High paging activity with no load
    ... Actually just because the current output of vmstat doesn't show any ... paging activity, doesn't mean that the system isn't paging. ... expecially if the database is filesystem based, since by default, AIX ...
    (comp.unix.aix)
  • Re: SelectCountMethod error - looking for parameters?
    ... of course you need to retrieve the total row count from the database to ... one call to the database server. ... the database in the SelectCountMethod (with most custom paging schemas ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SelectCountMethod error - looking for parameters?
    ... of course you need to retrieve the total row count from the database to ... one call to the database server. ... the database in the SelectCountMethod (with most custom paging schemas ...
    (microsoft.public.dotnet.framework.aspnet)
  • How would the God of Standard Sql - Celko do server side paging?
    ... On a very large database, how would Celko implement paging. ... To do paging on the database side, you must use some sort of ordering/ ...
    (microsoft.public.sqlserver.programming)
Loading