> I know you can zero out the cachedwithin times, but that > doesn't seem feasible as the caches are in all sorts of CFCs and have > various timeouts assigned.
It's worth noting that the caching is keyed on the text of the query. And once you execute it once with a timeout low enough that it hits the database, that updated data will be available to all of the places that query is run with a longer timeout. So if you can, immediately after an operation that should invalidate the cache, run that query with a zero second window, that new data will be visible in all of those other CFCs. (On a side note, perhaps it would be wise to factor these queries out into their own methods/CFCs, with an argument to specify the cachedwithin value that should be used. Then your cache-invalidation procedure would just be to invoke the same method everything else does, with a lower value. And everyone is guaranteed to share the same query code.) Sixten ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252383 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
