I need to update a product table which currently has 1 million rows. For each row, I need to perform an expensive http operation and then update 1 field in the row based on a returned header.
I've read that it might be faster to insert into a new table than updating an existing one. Is that true and, if so, why?
What alterable properties of the product table e.g. Indexes might slow down updates? There are a number of indexes on the table (i did not create these).
MySQL version is 5.6.12 and the engine is MyISAM