Title: SQL Process – Excessive?
Last modified: April 19, 2020

---

# SQL Process – Excessive?

 *  Resolved [lapa34c](https://wordpress.org/support/users/lapa34c/)
 * (@lapa34c)
 * [6 years ago](https://wordpress.org/support/topic/sql-process-excessive/)
 * 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: [http://visitoswegocounty.com/more-to-see-do/calendar/](http://visitoswegocounty.com/more-to-see-do/calendar/)
   CSS: my-calendar.css Requester Email: [chad.lapa@gmail.com](https://wordpress.org/support/topic/sql-process-excessive/chad.lapa@gmail.com?output_format=md)
   Admin Email: [chad.lapa@gmail.com](https://wordpress.org/support/topic/sql-process-excessive/chad.lapa@gmail.com?output_format=md)
 * ==WordPress:==
    Version: 5.4 URL: [http://visitoswegocounty.com](http://visitoswegocounty.com)
   Install: [http://visitoswegocounty.com](http://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: [http://www.elegantthemes.com/gallery/simplepress](http://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](https://wordpress.org/support/users/joedolson/)
 * (@joedolson)
 * [6 years ago](https://wordpress.org/support/topic/sql-process-excessive/#post-12702963)
 * 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.

 * ![](https://ps.w.org/my-calendar/assets/icon-256x256.png?rev=1097576)
 * [My Calendar - Accessible Event Manager](https://wordpress.org/plugins/my-calendar/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/my-calendar/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/my-calendar/)
 * [Active Topics](https://wordpress.org/support/plugin/my-calendar/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/my-calendar/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/my-calendar/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Joe Dolson](https://wordpress.org/support/users/joedolson/)
 * Last activity: [6 years ago](https://wordpress.org/support/topic/sql-process-excessive/#post-12702963)
 * Status: resolved