# optimize query

**URL:** <https://forums.percona.com/t/optimize-query/2895>\
**Category:** Other MySQL® Questions\
**Created:** [August 21, 2013, 10:32pm UTC](https://forums.percona.com/t/optimize-query/2895 "2013-08-21T22:32:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jpospos](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jpospos/32/954_2.png) [@jpospos](https://forums.percona.com/u/jpospos)\
**Post date:** [August 21, 2013, 10:32pm UTC](https://forums.percona.com/t/optimize-query/2895/1 "2013-08-21T22:32:49Z")

</div>

Hi, I need some advice regarding this query.

[URL][https://tools.percona.com/query/PTsWIJSJ/advice[/URL]](https://tools.percona.com/query/PTsWIJSJ/advice%5B/URL%5D)

I’ve already optimized my MySQL server configuration usually it takes around 300-380 seconds to finish, after optimization it now just takes around 100-120 seconds.

Querying happens from a remote server but on a local network.

Thanks,

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [August 22, 2013, 7:17am UTC](https://forums.percona.com/t/optimize-query/2895/2 "2013-08-22T07:17:01Z")

</div>

This is really complex query, joining many tables with some sub-selects. Definitely it’s not OLTP type, so don’t expect it to finish in less then second 🙂  
Provide EXPLAIN plan and all related tables definitions, maybe there are some index opportunities to make it faster.