A good start would be to view the estimated execution plan in query analyzer... It'll show which index you're using on that query... Chances are it's not the right query. Make sure it isn't doing a table scan... That's usually what slows it down...
-----Original Message----- From: Jared Clinton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 4:21 PM To: CF-Talk Subject: RE: updating large verity collection 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
