Jump to content

[1.7] Deleting products from catalog is slow (eshop with 300 000+ products)


sooly
 Share

Recommended Posts

Hello dear Prestashopers,

my question is simple and none of tips i found here on forums didnt help.

When I have eshop with 300 000+ product and want to bulk delete 100 products deleting becomes extremly slow. For example it deletes 1 product per 2 minutes.

Is there any way to speed it up?

Share this post


Link to post
Share on other sites

  • 10 months later...
  • 6 months later...

Same problem with 1.7.6.8 in 2021 😁

5000 products in shop

 

Deleting products with `(new Product($id))->delete()`

100 products takes 5 minutes. Does any one know how to figure it what process is slowing the process?

Share this post


Link to post
Share on other sites

This deceleration is caused by different hooks of different modules.
The biggest retarder is the Mail Alert module and also the category or the category_product table.
For example, you have 5000 products and each is in 4 categories.
A query must be sent to the 20,000 Prestashop function, which adds the position of the product in the category.

  • Like 1

Share this post


Link to post
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
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More