MySQL Forums
Forum List  »  Performance

Help: which kind of JOIN?
Posted by: Dean C.
Date: November 05, 2005 08:32AM

Hi,

I kind of solved the other problem I had that I posted in the replication forum and also updated the post with my solution.

To solve above issue I am reading about INNER JOIN, LEFT JOIN, RIGHT JOIN and still trying to speed up the statement.

I was able to get a huge improvement in speed when changing the startup values and increasing memory size. But I still have the feeling that further improvement can be made with an effective statement which uses the index correctly.

I appreciate any help!

Options: ReplyQuote


Subject
Views
Written By
Posted
1773
November 03, 2005 10:32AM
Help: which kind of JOIN?
1205
November 05, 2005 08:32AM


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.