We have a database of about 600,000 live (active) items.
So far each item has one and only one price at which it is sold.
SOME items (not all of them, a minority) will eventually sell at different prices in SOME stores.
I suggested to add a table:
If the idstore/iditme combination is NOT FOUND, then the selling price for this item is the one already stored in our 600,000-item table it the "price" column.
Another persons suggests that we should create a table:
And add there all 600,000 items for the time being. If prices change for another store, then, all 600,000 rows of the new
should be inserted, even though 98.5% of all rows will have exactly the same price for the same combination of IDITEM-ITSTORTYPE.
How should this be managed?
Thank you for any advise on this.