No, actually Client variables are stored in the registry, and there is now
an option to store them in an ODBC datasource. Session variables are stored
in memory along with all the other scopes.
-----Original Message-----
From: Judah McAuley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 13, 2000 12:25 PM
To: [EMAIL PROTECTED]
Subject: Re: Query Caching
At 11:23 AM 4/13/00 -0400, you wrote:
>Yes. You can save the query to SESSION scope.
>
><cfif NOT IsDefined("SESSION.QueryName")>
> <cflock name="#SESSION.SessionID#" timeout="30">
> <cfquery name="SESSION.QueryName" datasource="#dsn#">
> SQL STUFF
> </cfquery>
> </cflock>
></cfif>
>
>HTH!
>Sharon
One problem I worry about with this: Session variables are frequently
stored in the Registry on NT machines, yes? So if you had a very large
query, or quite a few users, you are potentially packing a lot of info into
the registry. Perhaps unwise.
Judah
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
