So how do you guys handle updating very large collections? >From a query (I'm using MSSQL Server).
CF 5.0 As I understand it, I can update incrementally, without overwriting the previous updates, but I'm not sure how to do it. CFQUERY has a Maxrows attribute, but apparently not a startrow/endrow pair. I thought I would try something like this: SELECT ARCHIVE_ID blah, blah, blah, FROM table WHERE ARCHIVE_ID BETWEEN 1 and 10000 i.e. "between #form.startrow# and #form.endrow# But in query analyizer, this query takes FOREVER to run. What are my other options? H. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
