I have a Magento 2.2.5 store with ~20k products and ~250 categories arranged in a tree of maximum 2 sub categories.
One of the top categories has 5k products and when I try to remove a product from the category, or remove the category for a specific product the server takes more than 2 minutes and times out.
After reading the general_log, I saw thousands of queries like this:
SELECT `e`.* FROM `tmp_select_e5e424ef98e4a8a4026e18df9d8088e0` AS `e` WHERE (hash_key = '1_44083')
peaking the database server to 100%:
I think this has something to do with url_rewrites, but I can’t seem to understand how is this a problem with only 5k products.
Are there any configurations I can set maybe loosing functionalities, to be able to do something as simple as removing a product from a category?
Thanks a lot.