Try using the index tuning wizard (you can find it in query analyzer), or if you have a DBA ask them for some advice. Reduce the number of columns returned to minimum neccesary.
-----Original Message----- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 22 January 2003 11:45 AM To: CF-Talk Subject: RE: updating large verity collection I have an index on the column ... the query is still taking more than minute (I never let it run longer, cause there's no point) to run. I'm not surprised, it looks like an expensive query since it is, as I understand it, like running 10,000 different one-item look ups. So I still need an answer -- and I'm looking every where on the Web for it to ... how do I break up the update of my verity collection update into managable chunks? H. > -----Original Message----- > From: Jared Clinton [SMTP:[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. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
