|
 |
asp_web_howto thread: Recordset Paging
Message #1 by williams@s... on Fri, 28 Sep 2001 13:35:23 -0400
|
|
Hi,
Anyone know how to pass a recordset back to ADO that contains only one
page's information.
I found a lot of articles about paging the whole result recordset to html.
However, as my database has millions of records, it takes long time to get
the whole recordset and even cause error:
Microsoft OLE DB
Provider for SQL
Server (0x80040E31)
Timeout expired
So I think if I only pass , say 1K records out of 20K possible records, to
ADO , then I may get a faster response.
Am I right? Any suggestion?
Thanks
William
Message #2 by "Ruth Nisenbaum" <ruthnis@0...> on Sat, 29 Sep 2001 06:25:15 +0200
|
|
Hi:
In your SQL query you should limit the amount of records that should be
returned from the server.
Look at Select top 200 ......
> Subject: Recordset Paging
> From: williams@s...
> Date: Fri, 28 Sep 2001 13:35:23 -0400
> X-Message-Number: 15
>
>
> Hi,
>
> Anyone know how to pass a recordset back to ADO that contains only one
> page's information.
>
> I found a lot of articles about paging the whole result recordset to html.
> However, as my database has millions of records, it takes long time to get
> the whole recordset and even cause error:
>
>
> Microsoft OLE DB
> Provider for SQL
> Server (0x80040E31)
> Timeout expired
>
>
>
> So I think if I only pass , say 1K records out of 20K possible records, to
> ADO , then I may get a faster response.
>
> Am I right? Any suggestion?
>
> Thanks
> William
>
>
|
|
|
View Cart
