What you're looking for is for the user to know that something is happening while the page is finishing, and not just have a blank white page while the whole page is being processed So stick a CFFLUSH after any headings are output, this will get the ball rolling. Also remember that most browsers will not render a table until all of the table has been received, so there is not much point doing a CFFLUSH between table rows unless you also close the table and then reopen it. Specifying column widths will help (mostly) keep that table columns lined up if you do this.
I've done this to a particularly long slow page output that was frustrating users. The overall processing time was no different, but the perceived waiting time was , much smaller because _something_ is changing on the screen, even if its just the titles appearing, then the first page or so of results will keep them happy while the rest are slowly trickling out. This makes for much happier users. To answer your original question, there should be no problems with CFFLUSH in a CFLOOP. 2 things to remember anytime you use a cfflush though: 1. You can't do a CFLOCATION anytime after you use a CFLUSH. 2. You can't use any CFFORM tags after you use a CFLUSH. Not that I'm advocating CFFORM tags. Personally, I think they're evil, but apparently they write stuff into the top of the page (all that crappy javascript they use) and this can't be done if the top of the page has already been sent down to the user. CFFLUSH is your friend. Regards Darren Tracey > -----Original Message----- > From: Andrew Dickinson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 3 February 2004 8:40 AM > To: CFAussie Mailing List > Subject: [cfaussie] cfflush inside cfloop > > > Any recommendations for using cfflush inside cfloop ? > > We run a number of very slow and bulky queries. For a report that > displays, say, a hundred results, I'd like to be able to show > them ten at > a time. (Not page-split - ten then then then ten etc on the > same page). > These queries are bulky because they process thousands of records and > display, say, the top hundred. > > All the examples and doco I've read about cfflush only > demonstrate how to > slow down a query in order to show a "please wait" message. > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
