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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
