Don't use Cold Fusion .... Use the SQL import tools and create an other table.
Use SQL to Insert data where not exists. Yanik Lupien -----Message d'origine----- De : Mark Warrick [mailto:[EMAIL PROTECTED]] Envoy� : Friday, March 15, 2002 14:03 � : SQL Objet : need help with large database update 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/ ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
