How to Optimize COUNT Query on a Bugs on a large Table with Existing Index Constraints?
I’m working on a query to count the number of bugs created on 2019-03-01 or later from a bugs
table with the following schema:
Querying 3 tables that return 32 records took 11 seconds. How to improve query?
I am doing a database query using PHP and wordpress.
In the query below, it’s taking too long to return the results.
(32 total, Query took 11.4666 seconds.)
The database server is returning a timeout error when the result count is more than 500.