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/ > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
