>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.
Here's an article I blogged a long time ago that gives you a stored procedure you can use with SQL 2k for doing pagination at the database level: http://blog.pengoworks.com/blogger/index.cfm?action=blog:546 I've used the stored proc on several projects where it breaks extremely large resultsets up and it works very well. One tip, since it does build the SQL statements on-the-fly, you'll want to create views for any complex queries where you need joins. -Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
