[Moving this to [EMAIL PROTECTED] Please make sure you reply to that
address!]
its just occured to me, that the easiest way to refresh all cached queries,
would be to cache a load of dummy queries up to the maximum that CF
administrator allows:
<cfregistry action="GET"
branch="HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Server
"
entry="MaxCachedQueries"
variable="NumQueries"
type="String">
<cfloop from="1" to="#NumQueries#" index="i">
<cfquery datasource="#request.dsn#"
name="q_#i#"
cachedwithin="#CreateTimeSpan(0,0,0,1)#">
SELECT NULL
WHERE #i# = #i#
</cfquery>
</cfloop>
Any reason why that should't work?
Bert
> -----Original Message-----
> From: lee borkman [mailto:[EMAIL PROTECTED]]
> Sent: 04 June 2001 16:10
> To: Fusebox
> Subject: Re: Query Caching
>
>
> Kevin, I think you may be misunderstanding how CF query
> caching works. The
> NAME of the query is irrelevant, and so is the "owner". The
> only thing
> important is the actual SQL code. If two users are running
> cached queries
> that have exactly the same code but different names, then
> caching will be
> used. All you need to worry about (unless you're using
> clustered servers -
> a whole different matter) is that you refresh your cached
> queries whenever a
> data change renders the cached recordset outdated.
>
> I recommend Steve Nelson's stuff on FuseBox.org, which goes
> into query
> caching pretty thoroughly. All in all, it's a lot easir to
> manage than it
> sounds. FuseBox makes it even easier, because of the way we
> naturally
> separate out our queries. That makes refreshing a breeze,
> for example.
>
> Have fun,
> LeeBB
>
> >From: Kevin Bridges <[EMAIL PROTECTED]>
> >What is the best way to cache queries in the following
> scenario? I have a
> >search screen that posts to a frameset in which there are 4
> frames that all
> >use different parts of the query. Behaviors are defined that let a
> >scrolling action in one frame control scrolling in other
> frames so the data
> >has to synch ... meaning the same query must be used for all
> 4 frames.
> >Because it is a search interface multiple users may be
> entering different
> >criteria for the search in rapid succession.
> >
> >From my understanding if I just cache the query for a set
> time period it
> >becomes cached for all users ...
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
