SQL Process – Excessive?

  • Resolved lapa34c

    (@lapa34c)


    4 years, 10 months ago

    Hi guys –

    I am seeing a massive amount of SQL calls running constantly from the site. The query is always the same (see below) and it runs several times per second. Any idea why this is happening?

    SELECT *, UNIX_TIMESTAMP(occur_begin) AS ts_occur_begin, UNIX_TIMESTAMP(occur_end) AS ts_occur_end FROM wp_my_calendar_events JOIN wp_my_calendar AS e ON (event_id=occur_event_id) JOIN wp_my_calendar_categories AS c ON (event_category=category_id) JOIN wp_my_calendar_category_relationships AS r ON r.event_id = e.event_id WHERE event_flagged <> 1 AND event_approved = 1 AND r.category_id IN (16,3,1,7,2,14,6,22,23) AND ( DATE(occur_begin) BETWEEN ‘2020-04-01 00:00:00’ AND ‘2020-04-30 23:59:59’ OR DATE(occur_end) BETWEEN ‘2020-04-01 00:00:00’ AND ‘2020-04-30 23:59:59’ OR ( DATE(‘2020-04-01’) BETWEEN DATE(occur_begin) AND DATE(occur_end) ) OR ( DATE(‘2020-04-30’) BETWEEN DATE(occur_begin) AND DATE(occur_end) ) ) ORDER BY occur_begin, event_title ASC

    ================ Installation Data ====================
    ==My Calendar:==
    Version: 3.1.18
    DB Version: 3.1.18
    URI: https://visitoswegocounty.com/more-to-see-do/calendar/
    CSS: my-calendar.css
    Requester Email: [email protected]
    Admin Email: [email protected]

    ==WordPress:==
    Version: 5.4
    URL: https://visitoswegocounty.com
    Install: https://visitoswegocounty.com
    Language: en-US
    Charset: UTF-8

    ==Extra info:==
    PHP Version: 7.3.16
    DB Version: 5.5.30
    Server Software: Apache
    User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:75.0) Gecko/20100101 Firefox/75.0

    ==Theme:==
    Name: SimplePress-Latest
    URI: https://www.elegantthemes.com/gallery/simplepress
    Parent:
    Version: 5.5.13

    Thanks guys for the help!
    Chad

Viewing 1 replies (of 1 total)
  • Plugin Author Joe Dolson

    (@joedolson)

    That’s a pretty run of the mill event query; it runs whenever the calendar is displayed. If it’s causing problems, you might want to consider using a caching plug-in, such as WP Super Cache.

Viewing 1 replies (of 1 total)
  • The topic ‘SQL Process – Excessive?’ is closed to new replies.