cache your query so u dont have to access the database each time Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113
________________________________ From: Rick Colman <rcol...@cox.net> To: cf-talk <cf-talk@houseoffusion.com> Sent: Thu, October 22, 2009 4:22:07 AM Subject: How to display LARGE amounts of Data in a Timely Fashion I need to query, retrieve and display a large amount of data; i.e. 4100 rows by 50 columns of numerics, to the browser screen. It is really slow, and after some testing, the bottleneck seems to be on the page that displays the data. The query is OK and connection is ok. But, the user has to wait an unacceptably long time for the results to show. Ideally, I would like to break the returned data into about 10 "spreadsheet-style" grids, with one grid per tab. TABLES is way too slow. Any ideas on how to render the displayed data quickly would be appreciated. Rick. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4