I agree with Judah plus it would seem a waste of resources, why not the
Application scope instead? That would make more sense to me. also use the
cachedwithin="()" setting in the query.
Fred T. Sanders
Galveston Island, TX
------------------------------
Having a bad day?
Imagine this...
You are in total seclusion from that hectic place called "The World".
The soothing sound of a gentle waterfall fills the air with a cascading
serenity.
The water is clear.
You can easily make out the face of the person you are holding underwater.
Feeling better?
----- Original Message -----
From: "Judah McAuley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 13, 2000 11:25 AM
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.
