Re: Optimize Query with multiple joins

[Angel Lacustre]

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.