sql performance problems concerning the upload of images

[Crowder]

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,

Crowder