Look, it's tuned, it's optimized, it's indexed. I'm not asking how to run this query better ... I'm asking for other options.
If I want, I can select 2,000 rows (5 seconds to run this query) at a time with this query, but that's rather ridiculous to contemplate when this database reaches 100,000 rows (though before then I'll probably need to break thing up into separate collections). I need something that can update Verity 10,000 rows at a time (or hell, maybe even only 5,000 rows), at least. Surely, somebody has dealt with this problem before and has some suggestions. H. > -----Original Message----- > From: Jared Clinton [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, January 21, 2003 4:59 PM > To: CF-Talk > Subject: RE: updating large verity collection > > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
