How to manage products attribute table

[betty88]

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]

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