I'd do seperate pages with forward/back buttons. If that isn't an option then look into CFFLUSH or increasing the timeout for that page.
HTH Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com ----- Original Message ----- From: "Nick Betts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 05, 2002 7:44 AM 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 > > > > ______________________________________________________________________ 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
