I have encountered a similar issue recently. I tried to use the Ajax cfgrid, but found it lacking. I had someone develop an Ext JS 2.0 grid to test out speed at handling large data sets, and it was a decent speed if we kept it under 50 rows per page. Right now I am trying the Flex DataGrid, which should be faster than JavaScript. The current version of JavaScript isn't designed to be high performance, and it will struggle if you ask it to do too much. Firefox seems much faster than MSIE when it comes to JavaScript, at least in my testing.
Ext JS 2.0 has one of the best grids. The jQuery tables are probably a bit faster since they are lighter weight. Yahoo has a beta data grid that looks nice, but it isn't very fast. Gzip could help if you are sending lots of data to the client. It helps to identify the source of the slowness. You have database time, ColdFusion time, data transfer time, and browser rendering time. Each one is addressed differently. Good luck, Mike Chabot On 10/31/07, cftalk cftalk <[EMAIL PROTECTED]> wrote: > All, > > I have a conundrum that I can't seem to find a good enough solution too. I > know what I need to do is archive data and only bring in data as needed to > search on, however, I can't go that route due to resources. > > I'm trying to page, sort, etc very large data sets and performance is > becoming an issue. I'm running SQL 2000 and CF7. I would like to be able > to have a nice AJAX paging option that performs well on very large datasets > but any other option is open to consideration. Please let me know your > thoughts on this. > > Thanks, > B ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292440 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
