Your problem is probably render time, which makes sense if you have a ton of data coming out in a table layout.
What you can do is remove as many of the tables as possible, especially for any layout stuff, headers, footers and the like. If you wrap the entire contents of the page in a table, your page has to finish downloading and then figure out how to render, which takes time. You can streamline this process by using CSS to lay your page out. Another thing, and probably the best increase, is if you use a fixed table layout (table-layout:fixed; in CSS). That will render your table with the same dimensions as your first table row, thus forcing the rest of the rows to fall in line. With that set, the browser doesn't have to download the whole table to start rendering it, it renders as it downloads. Another trick that I see around lately is the automatic scroll loading (don't know the official term). The idea is that once someone reaches the bottom of a page of data, more data loads, so you never really reach the bottom until the data has all been loaded. Google Reader was one of the first big sites to do this, but now it's more common. With this trick, you only need to load a couple pagefuls of data at a time. Consider that last one, sure, but DO those first two, for real. nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] On Wed, Oct 21, 2009 at 8:22 PM, Rick Colman <rcol...@cox.net> wrote: > > 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:327529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
