|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Paging ADO Recordset |
|
From: |
Jou Yao |
|
Date: |
7/2/2003 6:12:30 AM |
|
IP: |
203.198.235.62 |
I am writting a search Engine in ASP and SQL2000. Since the there is heavy loading in SQL Server when searching and there would be 500+ result records displayed. I want to separate the result records in different pages and don't want to use PAGESIZE and ABSOLUTEPAGE. Those 2 parameters of ADO Recordset require to start new query time by time if changing ASP page to view different result records.
My solutions are as below,
1. Store ADO Recordset object in Application Object. So the new query can be eliminated when changing page. I wonder there would be memory overloading if changing page for thousand times.
2. Use GETROW and tranfer all result records into Array. Then store Array into Session Object. However there will be 8 columns in a result record. Can I use 8-dimension array?
Anybody can help or have better idea. Many thanks!
Jou
jouberty@yahoo.com |
Follow Up - Re: Paging ADO Recordset - Si 7/19/2003 7:18:43 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
