I am facing this issue, where my dashboard loads really slow because the below query takes around 10 seconds, but the frontend works fine, the issue only appears on the backend.
SELECT comment_approved, COUNT(*) AS num_comments
WHERE comment_type NOT IN (‘order_note’, ‘webhook_delivery’)
GROUP BY comment_approved
I Got the details regarding slow query by using query monitor. Please help me with possible solutions.
- The topic ‘Slow dashboard due to Slow Comment count query.’ is closed to new replies.