I got a dev website with 250k products. Everything seems pretty smooth until I get on the Catalog Product Page. A simple product search on that page takes more than 30 secs...
On the front end, the same product is found in 1-2 sec.
Is there something obvious that I should check out? Otherwise it is painful to manage many products when it take so long to load "Catalog Product Page"
Using CE 2.4