What's your database engine?
At 11:02 15/03/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/
>
______________________________________________________________________
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
