Large Query output - cfflush?

[Jellyhead]

I have an exceptionally large query that I run once a week, and it has now become very cumbersome.  at any given time its 20 000 records or more.

I want to output to page as the query runs - trying cfflush but it does not seem to work.

Anyone have any suggestions - running CF 8.

[Dan_Bracuk]

Unless there is something else in your code to mess up cfflush, something like this should work.

<cfoutput>

#record#

<cfflush>

</cfoutput>