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 the 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. It 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 ______________________________________________________________________ Dedicated Windows 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=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
