|
|
|
|
|
| | |
| |
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
