MySQL Forums
Forum List  »  Performance

Re: Foreman query optimization
Posted by: Kyle Flavin
Date: November 05, 2015 06:54PM

Hi Peter,
Thanks, I checked it out. It looks like the author states that the LEFT JOIN is about equivalent to using NOT IN. Neither seem to be running in a reasonable amount of time for me. I haven't had a chance to try NOT EXISTS yet, but according to the article, it's the least efficient of the three.

I'm also attempting to add an index to the source_id column. So far, the query still seems to be taking quite awhile.

Options: ReplyQuote


Subject
Views
Written By
Posted
1735
November 05, 2015 04:15PM
704
November 05, 2015 05:42PM
Re: Foreman query optimization
755
November 05, 2015 06:54PM
680
November 05, 2015 11:19PM
772
November 06, 2015 11:58AM
695
November 06, 2015 12:35PM
672
November 06, 2015 06:44PM
766
November 26, 2015 08:56PM


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.