Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Change Database Structure to Improve Performance


Maryw

Recommended Posts

Posted

I am going to have a lot of options and option values for my store. I wonder if there is anything I can do to the database to improve the preformance.

 

Since the products' options and option values will also be stored in the products attribute table, I wonder if I can remove the products options to products option values table. I do not need to change the option names and option values once they are entered into the store. I will only use the easy populate to import each product along with its attributes information once to the store and I do not use the attribute editor in admin. In this case can I remove the products options to products option values table? And which files will be affacted and what search query modifications I will need to make?

 

Also since my product option values table is going to be pretty large, I wonder if I can split it into smaller ones by each language. That is one product option value table holds only option values in one language. And in this case, which files need to be edited and what query modifications need to be made?

 

Can I also split the product attributes table by product option? So for each product option there will be a separate product attributes table?

 

Thank you.

Archived

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

×
×
  • Create New...