Hussain, Internet Explorer will not display the table until the entire thing is downloaded, while Firefox or Opera will render the table as it gets each row. It wont matter to IE if you flush it, it waits for the closing </table> tag to display =(
Also, you have to remember that each time you query that 8000 records, its loading into memory on the Coldfusion server, and it needs to transfer those records from your SQL / Database server over to Coldfusion. I think you would be best served to find a way to limit any query you do to only the records you are going to display on that page immediately. So, provide next and prior page links, or even a page listing, but don't pull them all at once. There are many cf tags out there that will do pagination. If you absolutely must query 8000 records at once, you may consider caching that into a shared scope (probably application scope) so that it only has to come from your database once. Chris Peterson -----Original Message----- From: hussain shaikh [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 8:18 AM To: CF-Talk Subject: Re: Help Needed for fine-tuning CF code I am actually displaying only 100 records per page, so I guess that should not be the problem. But is there any way by which I can display the contents of the table as the data is rendered by HTML. I have tried cfflush but it didn't worked out. Hussain. > If the CF is processing in 100 Ms then the problem lies with the HTML. > > > Do you have a nested table layout? If you do avoid it. > > Also if your creating say 1000 rows for the page, consider changing it > to mulitple tables i.e every 50 results create a new table. This > should mean the data appears in chunks of 50. You can also use cfflush > with this but I don't think it would be required in this situation. > > Something like this just above your </cfoutput> should help: > <cfif currentrow mod 50 EQ 0> > </table> > <table> </cfif> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267288 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4