# Query Advisor Results

**URL:** <https://forums.percona.com/t/query-advisor-results/2409>\
**Category:** Other Tools\
**Created:** [January 23, 2013, 4:19pm UTC](https://forums.percona.com/t/query-advisor-results/2409 "2013-01-23T16:19:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ZeTToG](https://avatars.discourse-cdn.com/v4/letter/z/f04885/32.png) [@ZeTToG](https://forums.percona.com/u/ZeTToG)\
**Post date:** [January 23, 2013, 4:19pm UTC](https://forums.percona.com/t/query-advisor-results/2409/1 "2013-01-23T16:19:43Z")

</div>

> **[Percona Toolkit](https://www.percona.com/software/database-tools/percona-toolkit)**
>
> Choose from advanced command-line tools offered in Percona Toolkit to perform tasks like finding duplicate indexes and summarize MySQL servers. Optimize and tune database performance.

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

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

---

<div class="post-metadata">

**Author:** ![asif111](https://avatars.discourse-cdn.com/v4/letter/a/a8b319/32.png) [@asif111](https://forums.percona.com/u/asif111)\
**Post date:** [December 30, 2015, 8:10pm UTC](https://forums.percona.com/t/query-advisor-results/2409/2 "2015-12-30T20:10:56Z")

</div>

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.

[url][http://virtualassistantoutsourcingservices.com/[/url]](http://virtualassistantoutsourcingservices.com/%5B/url%5D)