InnoDB UPDATE slow need a better option
Using the information I've received from here, the web and several internet chat rooms, I've come up with.  Web source: http://www.softwareprojects.com/resources/programming/t-how-to-use-mysql-fast-load-data-for-updates-1753.html 


  DEMO: http://sqlfiddle.com/#!2/4ebe0/1


The process is:


Import into a new temp table.
Update The old table information with information in Temp table.
Insert new data into the table. (Real world I'm making a new CSV file and using LOAD INTO for the insert)
delete everything that is no longer in the data feed.
delete the temp table.


This seems the fastest processes so far.

Let me know what your opinion is.