paging disconnected recordsets 1

[vasah20]

Setup:
I've cached my data into Application-scope recordsets, and I intend to access them in my pages.

I have experience paging with connected recordsets, but this is my first time trying to page with disconnected recordsets.

Am I going to have a problem paging through them because I've disconnected them from the database? If so, do you guys have any workarounds / ways to increase performance?

I actually haven't started coding it out yet, but I figured this might save a little time

thanks in advance.

 

[hblackorby]

I'm not sure how paging affects disconnected recordset, but let me give you a little advice (use it how you will). Do not put your recordset into your application or session variables. You might think it will increase performance of your site, and it will if there are only a few users that on your site, but if you have a normal amount of users, it will dramatically decrease your performance. In an application-scope recordset, there is really only ONE connection, so if it's in use, other users will have to wait for one user to finish (one user at a time).

If you would like more technical explanation, try here:

http://www.learnasp.com/advice/dbsessionapp.asp

Hope this helps. Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO

 

[vasah20]

i know what you're talking about, but I explicitly defined the active connection as nothing. Won't that free up the one connection that was to be used by the Application level recordset?

ex:

set Application("rs") = server.createobject("adodb.recordset")
Application("rs").ActiveConnection = c
Application("rs").Open "Select * from table"
Application("rs").ActiveConnection = nothing

Won't this effectively be disconnected, allowing the connection to be freed, and only the data to sit in Application scope?

thanks in advance.