Is it possible to cache and reuse the results of a query
created in the code using QueryNew, QueryAddRow, etc.?
Yes, but not using CACHEDWITHIN/CACHEDAFTER. You can, of course, just stick
it in the Session or Application scope.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig
Thanks Dave. Earlier I had gotten the application scope to work, but I
assumed that it was a work-around to my failure with cachedwithin, so I
just kept attempting to work with cachedwithin. It is good to know that
not only is it not a work-around, but instead IS the way I need to
proceed. I
Is that query specific to an individual or the entire application?
If multiple users of your site hitting this page at the same time would
have different queries needing to cached, you will probably not want to
keep it in the application scope. The session scope would be more
appropriate in that
The application scope actually would work good in this instance because
the query I want to save and reuse is being built/parsed from a large
XML file that is updated daily. So, since the parsing is really slow, I
want to be able to cache the results file and use dynamic QofQs to pull
subsets of
4 matches
Mail list logo