You can use CFQUERY's BLOCKFACTOR attribute to control how many records are pulled from the database at one. (instead of taking them out one at a time).
If we're talking thousands of records, braeking it in several pages would be my suggestion (next page, previous page). -----Original Message----- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 10:44 AM To: CF-Talk Subject: Selecting many records at once 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 ______________________________________________________________________ Get Your Own 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=coldfusionb 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
