Question....Why are you comparing the data before updating? If the data that you are updating with is the same data, it would not matter and also if their is new data then that would be adjusted accordingly. Maybe I'm confused.
"Success is a journey, not a destination!!" Doug Brown ----- Original Message ----- From: "Kelly Matthews" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Friday, March 15, 2002 11:05 AM Subject: Re: need help with large database update > why not do it via a stored procedure... much quicker... > > ---------- Original Message ---------------------------------- > From: Mark Warrick <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Fri, 15 Mar 2002 11:02:51 -0800 (PST) > > >Hello All, > > > >I have a database of about 85,000 records which has 15 > >columns. I need to update this database with a > >datafile that contains the same schema and just as > >many records. > > > >For each row that is going to be imported, I have to > >compare all 15 columns of data for each row against > >all 15 columns of each row in the database to see if > >there's a match, and if not, then import the new data. > > > >Every query I've written with ColdFusion to do this > >seems to kill the server. Even comparing one row of > >data seems to put extreme load on the server. > > > >Anyone got a clue as to how I might accomplish this > >goal? I may be willing to pay somebody to do this. > > > >---mark > > > > > >__________________________________________________ > >Do You Yahoo!? > >Yahoo! Sports - live college hoops coverage > >http://sports.yahoo.com/ > > > ______________________________________________________________________ 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 Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
