you could use cachedwithin() attribute in you query tag.
On Tue, 5 Feb 2002, Willy Ray wrote: > I have a huge query that takes about 15 minutes to run. I'm a small > college, and I'm pulling data on my faculty and their class schedules, > office hours for posting on the web site. My legacy administrative > database was never designed for servicing the web, and it is just a > terribly long request to get all of this data. Currently, I'm caching th e > query for a week, and that seems to work pretty well. However, I'm > getting requests for changes to this application, and I'm considering a > re-write. > > One of the ways I'm thinking about doing this is to run my mongo-query, > and then loop through the results writing html, or cfm, files as I go. I t > would probably be about 300 pages. Is it like this: > > <cfoutput query="mondoQuery"> > <cffile ....><!--- set filename to #mondoQuery.id#.cfm --!> > > <!--- All my html, cfm, javascript, etc. for that ID --!> > > </cffile> > <cfoutput> > > Is that the best way? Advice? > > Willy Ray > Web Applications Developer > Westminster College > > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists