Okay, Then get 2000 rows, use the cfindex tag with action=update query=my2000rows then do a cflocation to the same script starting at row 2001
remember to exclusively lock all access to the verity collection while you are updating it, because not doing so will cause it to corrupt. Does this help? -Jared Clinton. -----Original Message----- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 22 January 2003 12:15 PM To: CF-Talk Subject: RE: updating large verity collection 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 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
