Not the answer you need?
Register and ask your own question!

Query Advisor Results

ZeTToGZeTToG EntrantInactive User Role Beginner

What does this mean?

Paginating a result set with LIMIT and OFFSET is O(n^2) complexity, and will cause performance problems as the data grows larger. Pagination techniques such as bookmarked scans are much more efficient.

Rule ID: CLA.003

SELECT wp_yASdr_posts.ID FROM wp_yASdr_posts INNER JOIN wp_yASdr_term_relationships ON (wp_yASdr_posts.ID = wp_yASdr_term_relationships.object_id) INNER JOIN wp_yASdr_term_relationships AS tt1 ON (wp_yASdr_posts.ID = tt1.object_id) WHERE 1=1 AND wp_yASdr_posts.ID NOT IN (336896,336889,336883,336872,336870,336835,336859,336823,336826,336819,336804,336792,336797,336791,336777,336766,336774,336761,336751,336749,336731,336738,336571,335527,334433,333935,333216,336647,336583,336376,336521,336435,336410,336391,336297) AND ( wp_yASdr_term_relationships.term_taxonomy_id IN (4) AND tt1.term_taxonomy_id IN (43,56,57,58) ) AND wp_yASdr_posts.post_type = 'post' AND (wp_yASdr_posts.post_status = 'publish') GROUP BY wp_yASdr_posts.ID ORDER BY wp_yASdr_posts.post_date DESC LIMIT 0, 4;</pre>

By the way, this query is slow. Please help to optimize it. Thanks


  • asif111asif111 Entrant Current User Role Beginner
    Why you should consider using virtual assistant services offered by us?

    We provide our valuable clients with administrative, creative and technical support from our dedicated offices at different geographical locations, using advanced technological modes of communication and data delivery. Hence, saving our clients the expense of office space and equipment as well as helping them stay focused on their core business activity and enjoy their personal life.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.