Buy Percona ServicesBuy Now!

Query Advisor Results

  • Filter
  • Time
  • Show
Clear All
new posts

  • Query Advisor Results

    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,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

  • #2
    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.