Hi there, we’re using The Grid on a multilingual site (using WPML which the The Grid says it supports) however our sites started slowing right down to the put they can take up to 30 seconds to load sometimes. Our host and developer found that The Grid is causing very long MySQL requests. This is a lot from the log.
SELECT wp_28_posts.*,NOW() FROM wp_28_posts LEFT JOIN wp_28_postmeta ON ( wp_28_posts.ID = wp_28_postmeta.post_id ) LEFT JOIN wp_28_postmeta AS mt1 ON (wp_28_posts.ID = mt1.post_id AND mt1.meta_key = ‘the_grid_language’ ) WHERE 1=1 AND ( ( ( wp_28_postmeta.meta_key = ‘the_grid_language’ AND wp_28_postmeta.meta_value LIKE ‘%en%’ ) OR mt1.post_id IS NULL ) ) AND wp_28_posts.post_type = ‘the_grid’ AND ((wp_28_posts.post_status <> ‘trash’ AND wp_28_posts.post_status <> ‘auto-draft’ AND wp_28_posts.post_status <> ‘flamingo-spam’ AND wp_28_posts.post_status <> ‘tco-data’)) GROUP BY wp_28_posts.ID ORDER BY wp_28_posts.post_modified DESC;
Any solutions here? our sites are becoming unaccessible for parts of the day because of it.