MySQL Forums
Forum List  »  Performance

Re: subquery vs. join?
Posted by: Magnus Olsson
Date: January 20, 2005 03:48AM

Hi,
I have experienced the same kind of problem. Smaller tables works fine and the performance is linear versus table length but at a certain size of the table the performence becomes drastically worse. For me it seems like I have reached some kind of limit e.g. the size of some buffer or not enough RAM etc, and MySQL have to start swap data onto the hard disk, which substantially prolongs the execution time.

My computer is basically just used as a MySQL-server and I wonder if there are any variables that can be adjusted to enhance performance for an issue like this?

Increasing the key_buffer_size, will that help and what are the drawbacks if it is set to high?

Options: ReplyQuote


Subject
Views
Written By
Posted
20406
December 03, 2004 02:52AM
7116
December 05, 2004 03:03AM
5930
December 05, 2004 07:52PM
Re: subquery vs. join?
6140
January 20, 2005 03:48AM
5281
January 20, 2005 06:52AM
4654
January 21, 2005 11:43PM
4854
January 21, 2005 11:38PM
3874
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.