I think you should look at solving your backend problem first - perhaps a data export to a different rdbms , or perhaps you should be running more, smaller queries. The paging thing would probably work, but I'm guessing it would be clunky and it would cause some of the same problems you have now (data not up to date etc.).
-----Original Message----- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 7:38 AM To: CF-Talk Subject: Write flat files based on HUGE query 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 ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
