As far as I can tell looking at the various suggestion, the most probable bottle neck is in your SQL code and not the CFM. Some stupid questions?
1. DO you have indexes on the table? 2. Which DB are you using? Different DB vendor will let you select only a subset of data i.e. SQL Server (Top 50) or mySQL (Limit 50) etc. Thanks Qasim On 1/23/07, hussain shaikh <[EMAIL PROTECTED]> wrote: > > 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:267286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
