• Resolved likedigital

    (@likedigital)


    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)
  • Hello,

    Thanks for reaching out to us about this.

    I am going to ask one of our developers to take a look at this to see if they can give a much better answer than I can.

    We should be able to get back to you very soon.

    Thank you so much,
    Chad

    Thread Starter likedigital

    (@likedigital)

    Thank you! I look forward to feedback.

    Plugin Support Abz

    (@abzlevelup)

    Hi @likedigital,

    I heard back from our team and lead dev, saying that — this is something we are working on with 6.0 where we optimize, and we are making things better, including the performance.

    We do not have a workaround for the current setup, however, we are really working hard on releasing 6.0 as soon as possible. We do not have any estimated time yet, but it’s a work in progress.

    Let me know if this helps.

    Best,
    Abz

    Thread Starter likedigital

    (@likedigital)

    Thank you very much ABZ! In your opinion, approximately how long it might take for the update? (3 weeks, 2 months, one year …?)
    Best regards

    Plugin Support Abz

    (@abzlevelup)

    Hi @likedigital, I am unable to provide you an exact date for when it will be available. However, we’ll notify our community, and we would release an announcement article. We are as excited as you are, for now hang tight, and we’ll keep you posted.

    Please do not hesitate to bump a new ticket on our way for different topics. Have a great day.

    Best,
    Abz

    Plugin Support Abz

    (@abzlevelup)

    Hi @likedigital,

    We haven’t heard from you in a while, so I’m going to mark this as resolved. Feel free to start a new thread if you have any more questions.

    Please do watch out for further announcements for our releases.

    Best,
    Abz

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Performance problem’ is closed to new replies.