betty88 Posted March 11, 2007 Share 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. Link to comment Share on other sites More sharing options...
pynchon Posted March 11, 2007 Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.