Re: optimizing JOIN query
Posted by:
Jay Pipes
Date: November 04, 2005 11:42AM
jimmie me wrote:
> as you can see i have to join the search_keywords
> and search_keyword_reference for every keyword i
> enter.
> This makes it a bit slow.
No, actually it does not. Having multiple joins on a single table set does not lead to poor performance, as MySQL will not have to read the same data from disk or memory twice. Having poor indexes on joined columns or poor search conditions, however, will definitely lead to performance problems.
Perhaps you might post an EXPLAIN SELECT of your queries?
Cheers,
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com
Subject
Views
Written By
Posted
1777
November 03, 2005 07:19AM
1134
November 03, 2005 07:54PM
1175
November 04, 2005 02:41AM
Re: optimizing JOIN query
1236
November 04, 2005 11:42AM
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.