Mysql InnoDB and quickly applying large updates
- by Tim
Basically my problem is that I have a large table of about 17,000,000 products that I need to apply a bunch of updates to really quickly.
The table has 30 columns with the id set as int(10) AUTO_INCREMENT.
I have another table which all of the updates for this table are stored in, these updates have to be pre-calculated as they take a couple of…