Jump to content

size of ps_product_price_index table


musicmaster

Recommended Posts

I checked my database and saw that the product_price_index table had over a million entries. This for a shop of just 1600 products.

Having a look at the table showed that the main problem is the country. The shop is enabled for all countries and that means that every product-currency combination is repeated 244 times. This is a Prestashop 1.7 innovation. 

Is there any way to reduce this high number?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...