Performance problem
-
Hello, I am requesting information on the performance of ‘The event Calendar’ plugin. we note that many very expensive queries are made, such as the following:
——————————-
# Query_time: 8.419967 Lock_time: 0.000367 Rows_sent: 9 Rows_examined: 2 391 973 Rows_affected: 0 # Bytes_sent: 11310 SET timestamp=1643757135; SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDate' ) WHERE 1=1 AND wp_posts.ID NOT IN (2489,2575,2637,2364,2181) AND ( wp_term_relationships.term_taxonomy_id IN (74,75,78,79,80,81,82,83,84,85) AND tt1.term_taxonomy_id IN (74,75,78,79,80,81,82,83,84,85) ) AND ( wp_postmeta.meta_key = '_EventStartDate' AND ( mt1.meta_key = '_EventEndDate' AND CAST(mt1.meta_value AS DATETIME) > '2022-02-02 00:12:00' ) ) AND ((wp_posts.post_type = 'tribe_events' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'mapped' OR wp_posts.post_status = 'needs_update' OR wp_posts.post_status = 'tribe-ea-success' OR wp_posts.post_status = 'tribe-ea-failed' OR wp_posts.post_status = 'tribe-ea-schedule' OR wp_posts.post_status = 'tribe-ea-pending' OR wp_posts.post_status = 'tribe-ea-draft'))) GROUP BY wp_posts.ID ORDER BY EventStartDate ASC, wp_posts.post_date ASC LIMIT 0, 9;
—————————–
However, other similar queries that perform very expensive calculations are common. The problem leads to frequent very frustrating slowdowns and automatic freezes when resource usage limits are exceeded. The queries are used for elements that expose, for example, the calendar or slider of a few events filtered by type. Is this large use of computation for simple elements normal? Can you help me. Thanks!
Viewing 6 replies - 1 through 6 (of 6 total)
Viewing 6 replies - 1 through 6 (of 6 total)
- The topic ‘Performance problem’ is closed to new replies.