slow query

  • Resolved jaymo1711

    (@jaymo1711)


    6 years, 3 months ago

    Hi, we’ve been getting a lot of queries from Events Manager showing up in the MySQL slow query log. They all look something like this:

    “SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_em_events.post_id FROM wp_em_events
    LEFT JOIN wp_em_locations ON wp_em_locations.location_id=wp_em_events.location_id
    WHERE (event_status=1) AND (recurrence!=1 OR recurrence IS NULL) A [truncated, 538 bytes total]”

    It’s a school website, so there are typically a lot of events. I’m hoping someone has suggestions for optimizing this query, as the server frequently gets bogged down with these queries.

    Thanks

Viewing 1 replies (of 1 total)

  • Hello,

    The queries from Events Manager should be optimized already. In which part of Events Manager page do you it to trigger? checking of the query it seems to get the row counts of locations.

    There is also a chance that the issue is on the Server itself, chances are MySQL Server is configured on your hosting properly. I have an EM installed on a cheapest hosting plan of Hostgator and I don’t have the same problem where sites became too slow.

Viewing 1 replies (of 1 total)
  • The topic ‘slow query’ is closed to new replies.