Plugin is slowing down the site
-
It seems this plugin is noticeably slowing down our server. We have close to 20,000 posts right now. Our hosting company is complaining that the following query is eating all of the cpu resources…
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
LEFT JOIN wp_postmeta PMWPAC3
ON PMWPAC3.post_id = wp_posts.ID
AND PMWPAC3.meta_key = ‘_wpac_show_in_search’
LEFT JOIN wp_postmeta PMWPAC
ON PMWPAC.post_id = wp_posts.ID
AND PMWPAC.meta_key = ‘_wpac_is_members_only’
LEFT JOIN wp_postmeta PMWPAC2
ON PMWPAC2.post_id = wp_posts.ID
AND PMWPAC2.meta_key = ‘_wpac_is_nonmembers_only’
WHERE 1=1
AND (((wp_posts.post_title LIKE ‘%toronto%’)
OR (wp_posts.post_excerpt LIKE ‘%toronto%’)
OR (wp_posts.post_content LIKE ‘%toronto%’)))
AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘wpdmpro’, ‘custposttyp1’, ‘custposttyp2’, ‘tribe_events’)
AND (wp_posts.post_status = ‘publish’
OR wp_posts.post_author = 785
AND wp_posts.post_status = ‘private’)
AND (PMWPAC2.meta_value IS NULL
OR PMWPAC2.meta_value != ‘true’)
ORDER BY wp_posts.post_title LIKE ‘%toronto%’ DESC, wp_posts.post_date DESC
- The topic ‘Plugin is slowing down the site’ is closed to new replies.
