My site is going really slow 2

[Samiaji]

Hi

I’ve moved to WPEngine now, and did all the needed cache, but the site is still going slow. Below are the database query from the event calendar that went for more than 0.05 seconds.

SELECT DISTINCT wp_posts.ID, MIN(wp_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate
FROM wp_posts
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.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_postmeta.meta_key = ‘_EventStartDate’ )
AND wp_posts.post_type = ‘tribe_events’
AND (wp_posts.post_status = ‘publish’
OR wp_posts.post_status = ‘closed’
OR wp_posts.post_status = ‘private’
OR wp_posts.post_status = ‘hidden’)
AND ((wp_postmeta.meta_value >= ‘2015-06-29 00:00:00’
AND wp_postmeta.meta_value <= ‘2015-08-02 00:00:00’)
OR (tribe_event_end_date.meta_value >= ‘2015-06-29 00:00:00’
AND wp_postmeta.meta_value <= ‘2015-08-02 00:00:00’ )
OR (wp_postmeta.meta_value < ‘2015-06-29 00:00:00’
AND tribe_event_end_date.meta_value >= ‘2015-08-02 00:00:00’ ))
GROUP BY IF( wp_posts.post_parent = 0, wp_posts.ID, wp_posts.post_parent )
ORDER BY EventStartDate ASC

——————————————-

SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate
FROM wp_posts
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.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_postmeta.meta_key = ‘_EventStartDate’ )
AND wp_posts.post_type = ‘tribe_events’
AND ((wp_posts.post_status = ‘publish’
OR wp_posts.post_status = ‘private’))
AND ((wp_postmeta.meta_value >= ‘2015-07-14 12:00:41’
AND wp_postmeta.meta_value <= ‘2015-07-31 23:59:59’)
OR (tribe_event_end_date.meta_value >= ‘2015-07-14 12:00:41’
AND wp_postmeta.meta_value <= ‘2015-07-31 23:59:59’ )
OR (wp_postmeta.meta_value < ‘2015-07-14 12:00:41’
AND tribe_event_end_date.meta_value >= ‘2015-07-31 23:59:59’ ))
GROUP BY IF( wp_posts.post_parent = 0, wp_posts.ID, wp_posts.post_parent )
ORDER BY EventStartDate ASC
LIMIT 0, 5

[George]

Hello,

What version of The Events Calendar is active on your site? Also, what version of Events Calendar PRO is active on your site?

I’m also curious if you see slowness across your site in general, or is it only on The Events Calendar-related pages and views? If so: which views? Does the Month View load a lot slower than the others, for example?

Thank you!
George

[Samiaji]

Hi

The Event Calendar version 3.10.1, Events Calendar PRO version 3.10.1, and The Events Calendar: Community Events version 3.10.

The Mini Calendar widget adds around 2 seconds to loading a page. The main calendar page (http://acara.co.id/events/) loads really slow. The map version (http://acara.co.id/events/map/?action=tribe_geosearch&tribe_paged=1&tribe_event_display=map&tribe-bar-geoloc-lat=-6.2087634&tribe-bar-geoloc-lng=106.84559899999999&tribe-bar-geoloc=Jakarta) won’t load at all.

Im using WPEngine professional version, so it’s supposed to be enough.

Can you pls find out whats wrong with the site?

[George]

Hey Samiaji,

Have you contacted WP Engine support about this directly? If not, can you try doing so? They may be able to find a specific source of this problem, which might help here.

I’m very sorry for your frustrations and hope to hear what the WP Engine support team have to say about this.

In the meantime, I’m curious if you’d be able to run through the troubleshooting steps we have outlined here → https://theeventscalendar.com/knowledgebase/testing-for-conflicts/

If so, check on performance after each step in that process. It’s possible that other code on your site is conflating these performance issues perhaps, these steps will help confirm or rule out whether that’s the cast or not.

Thank you for your patience!
George

[Samiaji]

Yes I have contacted WPEngine team and GoodNews theme team, they told me to contact the event calendar plugin team.

Have you done crash test on your plugin using thousands of data before?

My site contains 12000ish events.

Do you have a hint whats gone wrong? Have you check for the database queries I sent you prior to this email?

[George]

Hey Samiaji,

Thanks for the update – we have indeed done stress-testing on our plugin, but there are unfortunately some limitations with the number of events you’re dealing with.

“Events” are post types within WordPress, and there are performance issues in general with so much data – 12,000 posts, or pages for example.

We are hoping to improve scalability and performance of The Events Calendar in time but, at this time, if you have 12,000+ events then your errors here could simply be a matter of things timing out.

I’m sorry to bear this news – if you have purchased any add-ons within the last 30days, we’d happily issue a refund for them. if you’re interested in that, shoot an email to [email protected] with your original email receipts attached and we can proceed from there to issue the refunds.

Sorry to disappoint Samiaji!

[Samiaji]

Hi George

I’m not interested in not using the plugin. Your plugin really serves the purpose for the things that I need from my site. Please do not give up on this matter, okay. You guys already did a great job on the plugin!

So, this is what I can do in terms of searching for events:

Today’s Event in Jakarta (speed is okay): http://acara.co.id/events/today/?tribe-bar-geoloc-lat=-6.2087634&tribe-bar-geoloc-lng=106.84559899999999&tribe-bar-geoloc=Jakarta

This Week Event in Jakarta (speed is okay): http://acara.co.id/events/category/musik/week/?tribe-bar-date=2015-07-23&tribe-bar-geoloc-lat=-6.2087634&tribe-bar-geoloc-lng=106.84559899999999&tribe-bar-geoloc=Jakarta

Upcoming Event Jakarta in list (a little slow): http://acara.co.id/events/category/musik/list/?tribe-bar-date=2015-07-23&tribe-bar-geoloc-lat=-6.2087634&tribe-bar-geoloc-lng=106.84559899999999&tribe-bar-geoloc=Jakarta

Upcoming Event in Jakarta in photos (a little slow): http://acara.co.id/events/category/musik/photo/?tribe-bar-geoloc-lat=-6.2087634&tribe-bar-geoloc-lng=106.84559899999999&tribe-bar-geoloc=Jakarta

Upcoming Event in Jakarta in photos (very slow):http://acara.co.id/events/category/musik/map/?action=tribe_geosearch&tribe_paged=1&tribe_event_display=map&tribe_event_category=musik&tribe-bar-geoloc-lat=-6.2087634&tribe-bar-geoloc-lng=106.84559899999999&tribe-bar-geoloc=Jakarta

So my curiosity is whether your Google Map function is using an API Key that everyone is using? How did you slice your data in your database query, maybe something we can work on?

[George]

Hey Samiaji,

Your enthusiasm to keep using the plugin is much appreciated – we’d love for you to be able to keep using The Events Calendar, too, but my comments were simply to underscore the fact that if the core problem here is just a combination of our code and your server being unable to handle the load of 12,000 events, then we wouldn’t be able to correct this from our end of things at this time 🙁

That is hard news to share especially with a customer as awesome as yourself! Yes, we’d love The Events Calendar to keep working on your site – let’s see if we can make it happen, though I’m skeptical that it will handle the load no matter what we try here.

The first of your questions was about the Google Maps API Key – we don’t have an API key hard-coded into the plugin or anything, but the Google Maps works could cause issues if many people on the same network of sites are pinging its API. In other words, many shared hosts might have a bunch of sites on one cluster that all ping the same Google API endpoint, which Google counts as one traffic source and so the limit for API requests is shared among all those shared sites 🙁 It’s unfortunate and we’ve had a few customers run into issues with that in the past (although it is, admittedly, quite rare).

As for “slicing our data in our database query”, I’m not quite sure how best to answer this – we don’t do anything exceptional or fancy with our storage of and retrieval of Events in the WordPress database – we just basically use the default Post Type storage in $wpdb, so if you’re familiar with or can optimize the performance of default WordPress content like Posts, Pages, etc., you should theoretically be able to apply those principles to Events with little extra work.

I’m not sure of my answers here help, but I hope they do.

Cheers,
George

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts