The query is probably running slowly because you dont have the appropriate indexes defined and applied.
Look up how to manage indexes correctly in sql server books online, its worthwhile. -Jared Clinton. -----Original Message----- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 22 January 2003 11:09 AM To: CF-Talk Subject: updating large verity collection 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
