Jump to content

sql performance problems concerning the upload of images


Recommended Posts

Dear Community,


We´re currently experiencing problems while uploading several pictures at once with prestashop.

Our server often has serious performance problems for several minutes when we upload several pictures for our categories within a short period.


I attached a screenshot with all the sql commands that have been running in a period where we´ve encountered this kind of problem.


Apparently the operations that affect the temporary tables cause this kind of performance problem. I guess I´ve to add that we have 60k+ articles and more than 2k categories in our shop and so the temporary tables get pretty large.

But I dont see any solution to reduce the size of the temporary tables or to upload the pictures of our existing categories faster or in another way.


Has anyone encounter the same problem yet and/or has a solution for this issue?


best regards,



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...