MySQL Forums
Forum List  »  General

Re: Optimising query with many joins
Posted by: Benoit St-Jean
Date: March 31, 2017 04:15AM

What do you expect? You don't have much to filter based on your WHERE clause, BUT :

1) Remove the clause "1=1", it serves no purpose at all.
2) Try adding an index (display_picture, date_taken_formatted)
3) Perhaps tweak the sort buffer size?
4) Perhaps partition on display_picture ?
5) Can you post the SHOW CREATE TABLE for pictures and try #1 and #2 first and post the resulting EXPLAIN ?

Options: ReplyQuote


Subject
Written By
Posted
Re: Optimising query with many joins
March 31, 2017 04:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.