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
Are you using Elasticsearch? If so, go to /var/log/elasticsearch/ and check log message and post here.