betty88 Posted March 11, 2007 Posted March 11, 2007 If my total number of products reaches 1 billion and each product has around 100 options. Each option has 10 values. Then the products attribute table will look like: Products attribute id Products id Products option id Products option value id 1 1 1 1 ... ... ... 100,000,000,000 1000,000,000 100 10 Can anyone tell me what should be the best way to manage the data in this case? Should I split the table into smaller number of records or change some other tables? Thanks.
pynchon Posted March 11, 2007 Posted March 11, 2007 If my total number of products reaches 1 billion and each product has around 100 options. Each option has 10 values. Then the products attribute table will look like: Products attribute id Products id Products option id Products option value id 1 1 1 1 ... ... ... 100,000,000,000 1000,000,000 100 10 Can anyone tell me what should be the best way to manage the data in this case? Should I split the table into smaller number of records or change some other tables? Thanks. Why on earth would you be selling 1 billion products? Not even Amazon comes close ... and if you were selling on that scale, don't be such a cheap-skate and get someone to build a bespoke solution. :) jk
Recommended Posts
Archived
This topic is now archived and is closed to further replies.