MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimize Query with multiple joins
Posted by: Angel Lacustre
Date: March 24, 2011 07:02AM

Thanks for the fast answer, glad to know that the query plan is as good as it can be.

Your guess was right, the "d.id" is the alias for "dest". I guess my benchmarking simply wasn't that good, I'll remove the distinct.

Also, I'm aware of the non order by clause. I think it wasn't added in the beggining for performance reasons, I'll add it now.

That said, where could I investigate further the reason of this query being slow under heavy load? Maybe it's a hardware limitation?

Thanks again!

Angel



Edited 1 time(s). Last edit at 03/24/2011 07:04AM by Angel Lacustre.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Optimize Query with multiple joins
1921
March 24, 2011 07:02AM


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.