[Edward]

Hi Sky,

The event is already set to live.

Any other ideas?

Dave

[Edward]

Thanks Nico! That hotfix resolved the problem.

Cheers,
Dave

[Edward]

Hi,

I’m having this exact same problem.

I’ve had someone analyse the slow processes a few times and have been able to narrow it down to poor performing MySQL query. The query appears to be as follows:

SELECT uhkv_posts.ID FROM uhkv_posts INNER JOIN uhkv_postmeta ON ( uhkv_posts.ID = uhkv_postmeta.post_id ) INNER JOIN uhkv_postmeta AS mt1 ON ( uhkv_posts.ID = mt1.post_id ) INNER JOIN uhkv_postmeta AS mt2 ON ( uhkv_posts.ID = mt2.post_id ) WHERE 1=1 AND ( ( uhkv_postmeta.meta_key = ‘_VenueAddress’ AND uhkv_postmeta.meta_value != ” ) OR ( mt1.meta_key = ‘_VenueCity’ AND mt1.meta_value != ” ) OR ( mt2.meta_key = ‘_VenueZip’ AND mt2.meta_value != ” )) AND uhkv_posts.post_type = ‘tribe_venue’ AND ((uhkv_posts.post_status ‘trash’ AND uhkv_posts.post_status ‘auto-draft’)) GROUP BY uhkv_posts.ID ORDER BY uhkv_posts.ID ASC

Even running that in phpMyAdmin the query took 44.3788 seconds – and only returned 94 rows so its clearly badly optimised.

[Author]

Posts