Huge increase in queries with SEOPress enabled
-
I am troubleshooting some performance issues with my site. In doing so I have just uncovered a rather alarming issue.
The number of underlying queries to the database goes through the roof when I have SEOPress active. Specifically, the page I am using to research this goes from 141 SELEECT queries (with SEOPress not running) to well over 1400 when SEOPress is enabled. The majority of the queries are similar to the one below.
I suspect this could have something to do with LifterLMS (I am going to ask there too), which registers it’s own CPTs. But, as I say, if I deactivate SEOPress this issue goes away.
This is a pretty concerning issue and, for now, I have deactivated SEOPress. I’d appreciate any thoughts and suggestions.
Note : this happens even if I only have the free plugin activated.
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = '_llms_order' AND ( ( mt1.meta_key = '_llms_parent_section' AND mt1.meta_value = '2875' ) ) ) AND wp_posts.post_type = 'lesson' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'xlwctydisabled' OR wp_posts.post_status = 'llms-completed' OR wp_posts.post_status = 'llms-active' OR wp_posts.post_status = 'llms-expired' OR wp_posts.post_status = 'llms-on-hold' OR wp_posts.post_status = 'llms-pending-cancel' OR wp_posts.post_status = 'llms-pending' OR wp_posts.post_status = 'llms-cancelled' OR wp_posts.post_status = 'llms-refunded' OR wp_posts.post_status = 'llms-failed' OR wp_posts.post_status = 'llms-txn-failed' OR wp_posts.post_status = 'llms-txn-pending' OR wp_posts.post_status = 'llms-txn-refunded' OR wp_posts.post_status = 'llms-txn-succeeded' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 ASC LIMIT 0, 500
- The topic ‘Huge increase in queries with SEOPress enabled’ is closed to new replies.