While you await an answer to that, are you aware that you can at least mimic CF's variable-based query caching by assigning q query resultset to a persistent scope (such as session or application)?
I suppose you're referring to the CACHEDWITHIN and CACHEDAFTER attributes of CFQUERY. I'm sure many readers here will not be aware of that, so it may help to explain it so that they can offer JSP/servlet/tag library alternatives. These attributes of CFQUERY (which is CF's way to pass to a given datasource the SQL string to be processed) allow one to indicate that if the given query has been cached within a given time span (using CACHEDWITHIN) or as of a given date/time (with CACHEDAFTER), then the query is not really executed against the datasource but is instead retrieve from a cache automatically. It's nice (though it has its drawbacks). What's particularly useful is that the mere addition of either of these attributes to your query will cause CF to use the cache and manage its refreshing for you. No need to test for the cache, or manage the timespans, etc. It's handled for you. In fact, another cool thing is that the cache is shared among all applications (in effect, in what CF calls a "server" scope), such that if two applications run the same query against the same datasource using the same SQL (and any related parameters such as userid/password, etc) and they both used one of these CACHED attributes, they will share the same cache. /charlie -----Original Message----- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Friday, September 28, 2001 9:47 AM To: JRun-Talk Subject: Cached Queries Anyone know of a taglib that replicates CF's query caching ability? -----Original Message----- From: Jackie Comeau [mailto:[EMAIL PROTECTED]] Sent: Friday, September 28, 2001 9:17 AM To: JRun-Talk Subject: RE: JRun shared hosting This question gets asked a lot. Did you check the archives? On Thursday, September 27, 2001 5:53 PM, Drew Falkman [SMTP:[EMAIL PROTECTED]] wrote: > Hello all- > > Does anyone know of somewhere to host a personal site for a reasonable > price that offers the use of JRun? > > Thanks. > > Drew Falkman > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
