Hi,
I have a few very heavy queries, which only require updating about once a day.
I have used the caching function of CFQUERY, however, these queries are
frequently ejected from the cache, which puts periodic load on my DB server
when re-querying for this information.

I also attempted using CFCACHE to cache the page, however, the template is
nested as an include (due to other user-specific dynamic functions on the
site), but this obviously doesn't work quite right, as you get the whole page
as the cached include file, and not just the include itself.

I'm considering just scheduling a task that runs once per day, then writes the
result set in HTML to a template, which would be included in the dynamic
templates, thus preserving the "cached" query, and allowing for the generation
of user-specific content as well. I'm thinking this is the best option (thus
far), however, I was curious if there might be a better way to do this?

It would be SWEET if you could specifiy a priority level for query caching, so
only low priority queries are removed from cache....

Geoff B