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 ... So I was thinking of adding the cftoken to
the end of the query name and setting the time period really low ... but if
I set time period to low and user is on a slow connection I run the risk of
not having the query available to all 4 frames because they won't load in
time. If I set the time period to high then the user will not get new
information if the search returns no results and they decide to conduct
another search or they simply conduct a new search.
I read a suggestion of checking for an attributes flag to refresh the query
.... but the only way to refresh a cached query (please correct me if wrong)
is to generate a completely new query of same name with no cachedwithin
information ... If I do that then the 4 frames break because query is not
persistent.
Any suggestions or ideas?
Thanks,
Kevin Bridges
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
