|
|
|
|
|
| | |
| |
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: |
Re: Paging ADO Recordset |
|
From: |
Si |
|
Date: |
7/19/2003 7:18:43 PM |
|
IP: |
80.225.71.224 |
Hi Jou,
If your application is not hosted on a dedicated server I wouldnt use application variables to store the recordset data for 2 reasons:
1> It would be memory hungry (dependant upon data stored)
2> If your not on a dedicated server, chances are the server will reset often - wiping out the data held in any application variable.
Using the Recordset objects GetRows() method should give your application better performance - but storing it in a Session variable isnt a good idea as it would be memory intensive - and may crash the server (as each users session would hold xxx amount of data - and it all adds up).
Im not too familiar with SQL Server - but it may provide some way of of paging results from a query which would require less overheads (as it only returns the required number of records)...though you would still have to re-execute the query each time the page is loaded/paged.
For an example of paging data with the GetRows() function check out: http://www.juicystudio.com/tutorial/asp/getrows.html
Good luck |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
