Hi,<\/p>\n
Since upgrading to the latest TEC version my wp-admin area is VERY slow. It takes me over 22s just to log-in. No other changes have been made.<\/p>\n
I see other’s are registering this complaint too.<\/p>\n
I’ve had someone look at the site and we’ve analysed 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:<\/p>\n
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<\/p>\n
Even running that in phpMyAdmin the query took 44.3788 seconds – and only returned 94 rows so its clearly badly optimised.<\/p>\n
Could you please advise.<\/p>\n
Thanks,
\nDave
\nDavid Orchard (weblad.uk) on behalf of Eddie Ludlow.<\/p>\n","protected":false},"template":"","class_list":["post-1476617","topic","type-topic","status-closed","hentry"],"yoast_head":"\n