OK ... So it is based on the sql statement. If the sql changes then the
query is re-cached.
I just figured out I can't use caching because cold fusion generates this:
Cached query is not supported for SQL statements which use embedded
<CFQUERYPARAM> tag(s) ... which is totally lame.
I'm converting the query to wddx and solving the problem.
Thanks for the help.
-----Original Message-----
From: lee borkman [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 9:10 AM
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
