Thanks Alex.
Since my last message, the site has developed a major slow down every time I try and load the home page.
My hosting providers spotted the following error which is coming from the GD Events Plugin:
=========================================
SELECT wp_posts.*, wp_geodir_gd_event_detail.*, wp_geodir_event_schedule.* FROM wp_posts
INNER JOIN wp_geodir_gd_event_detail ON (wp_geodir_gd_event_detail.post_id = wp_posts.ID) LEFT JOIN wp_geodir_event_schedule ON wp_geodir_event_schedule.event_id = wp_posts.ID LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE 1=1 AND ( wp_posts.post_status = ‘publish’ ) AND wp_posts.post_type = ‘gd_event’ AND 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (61,63,66,330,331,335,336,339,340,345,353,364,365,380,381,390,391,412,428,434,457,460,473,482,489,505,519,520,583,613,681,695,761,910,1783,1848,1850,2029,2032,2036,2040,2049,2596)
)
GROUP BY wp_geodir_event_schedule.schedule_id
ORDER BY (( 29 * 0 ) + (wp_geodir_gd_event_detail.rating_count * wp_geodir_gd_event_detail.overall_rating )) / ( 29 + wp_geodir_gd_event_detail.rating_count ) DESC, wp_geodir_event_schedule.start_date ASC, wp_geodir_event_schedule.start_time ASC
LIMIT 0, 4
=========================================
After this, I turned off the Events plugin to test it, and when I do the site runs super fast.
Weird thing is, even though Events plugin is turned off, all events still show and work fine. Is this normal?
You can test it yourself. If you take a look at whatsonhub.co.uk you’ll see how it get stuck on loading. Just turn events off and you’ll see the difference.
There’s no caching plugin active right now either.
Thanks,
Dave
Kiran 4 years, 11 months ago.
