Thank you, but I don't have an answer please.
How did you remove products from the eshop, where there are now 10k products?
The SQL I gave you should have returned some number.
what was it like
I'm trying to figure out why an eshop with 10k products is so slow and an eshop with 30k products is fast.
There will definitely be some mess in the database.