Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How to manage products attribute table


betty88

Recommended Posts

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...