Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Best way to organize attributes


puckett_jw

Recommended Posts

Greeting all ?

 

I am contemplating the best way to keep attributes in the database. Currently I have just over 2000 products and about 4500 attributes. About 99% of my attributes are Titled ?Selection?, which leads to my question?

 

Is it best to have only one option named ?Selection? and put all of my 4500 option values in, or is it best to have multiple product options named ?Selection? to only put the necessary option values in?

 

The way the database seems to be designed, there does not seem to be a good correlation between the product and the product option name, so there does not seem to be a good reason to keep 520 product options named ?Selection?.

 

 

Thanks for any advise/pointers

-jimmy

Link to comment
Share on other sites

Let me try to point my question a little better?

 

I am trying to determine the best way to put my attributes in the database for the best performance, and in doing so I am trying to understand the relationship of some of the tables. Currently, I have about 500 Product Options name ?Select? and almost 4000 Option Values. So is it best to have a Product Option named ?Select? repeated in the database making 500 option_values_id, or is it better to only have one Select? Is there less query overhead? Is there better long-term reason for one or the other?

 

 

Thanks

-jimmy

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...