GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Query Advisor Results

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Query Advisor Results

    tools.percona.com/query-advisor/PT9WIJBg/advise

    What does this mean?
    Quote:
    LIMIT with OFFSET

    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,3 36777,336766,336774,336761,336751,336749,336731,33 6738,336571,335527,334433,333935,333216,336647,336 583,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;


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