Afternoon fellow CF'ers around the globe... I have an app that retrieves thousands of records from a database, looping thru them to display to screen. The query takes forever and the page times out. Can anyone suggest a way to prevent this by outputting the data in manageable chunks or is "paging" preferable?
TIA. Nick -----Original Message----- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 15:38 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
