MySQL Forums
Forum List  »  Optimizer & Parser

Re: At Performance Limit for 2 GB RAM?
Posted by: Nick Matheson
Date: August 08, 2005 09:26AM

KimSeong-

Initial results look promising on this index change. I tried it on the 20 million rows and got sub 0.1s performance. I will rebuild the indexes on the 200 million rows and do some more complete testing. Then I will post my findings. As you noted the filesort and temporary went away. (I think I had a different view of how the optimizer was solving the query, but when you brought up this change I think it final has dawned on me what the optimizer is trying to do.)

Thanks again,

Nick

Options: ReplyQuote


Subject
Views
Written By
Posted
3083
August 04, 2005 07:17PM
Re: At Performance Limit for 2 GB RAM?
2878
August 08, 2005 09:26AM


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.