Off the top of my head:
o Create a temp table with same structure as end result table
o bulk insert into temp table
o Write A SP
- user a cursor, loop thru all records in original table
- For each row, select from Temp the base matching row
(assumes there is a primary key)
- in the SP compare the columns of each selection
- if at least one does not match, break out early and
- perform an update on the current row for all fields
(variation is to update as you go)
And of course the other variation is to write a custom C or VB app
that reads the temp and origin tables into memory, does all of the
compares, sets flags as to what has to be updated, then updates
all of the rows as needed.
Anyway, those are my thoughts...
Steve
At 11:02 AM 3/15/2002 -0800, Mark Warrick wrote:
>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/
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
