Here are a few blog posts found on google showing how to handle pagination well
http://www.bennadel.com/blog/281-Oh-Baby-It-s-So-Hot-When-You-Paginate-a ka-Paginating-Results-In-ColdFusion-.htm http://ray.camdenfamily.com/index.cfm/2006/4/24/ColdFusion-and-Paginatio n Like many are saying though, pagination in the database request will be much faster when properly implemented. =) Chris -----Original Message----- From: hussain shaikh [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 8:47 AM To: CF-Talk Subject: Re: Help Needed for fine-tuning CF code Thanks Chris, You mentioned abt some tags for Pagination.What r those? Where on net I can get pagination stuff? >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:267294 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
