GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

optimize query

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

  • optimize query

    Hi, I need some advice regarding this query.

    https://tools.percona.com/query/PTsWIJSJ/advice

    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,
    Last edited by jpospos; 08-22-2013, 12:05 AM. Reason: Additional information

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

    Comment

    Working...
    X