MySQL Forums
Forum List  »  Performance

Re: subquery vs. join?
Posted by: James Day
Date: January 21, 2005 11:43PM

See the server system variables section of the manual. You want the maximum temporary table size variable. Remember that you can set this for each individual query/session, so you may be able to leave it small most of the time and make it large just for the query which needs it.

The key buffer size may also help but there is a cost: the RAM allocated for that in MyISAM isn't available in system cache to cache the data rows. So, you need to balance the two amounts.

Options: ReplyQuote


Subject
Views
Written By
Posted
20411
December 03, 2004 02:52AM
7119
December 05, 2004 03:03AM
5933
December 05, 2004 07:52PM
6143
January 20, 2005 03:48AM
5283
January 20, 2005 06:52AM
Re: subquery vs. join?
4656
January 21, 2005 11:43PM
4857
January 21, 2005 11:38PM
3877
January 20, 2005 04:41PM


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.