webfoo - 1:40 pm on Jul 31, 2013 (gmt 0)
Londrum, I was considering truncating the table and re-importing all 300,000 records because of how fast it is. However I decided against it because each item in the table has a auto_increment primary index that other tables reference. For example, the orders table might say that a customer ordered item 90461. If I truncate the products table every morning, and then add all the rows back in to it, item 90461 is not necessarily going to point to the same product it was before. Now we don't know which item the customer actually ordered.
In order to make this feasible, I'd need to reference each product with a dual key of supplier number and SKU number, from within the orders table. Any other thoughts before I rip apart my database design?