|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: mysql is dead slow
From: Perrin Harkins (perrin
elem.com)
Date: Mon Oct 20 2008 - 22:30:01 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Mon, Oct 20, 2008 at 10:15 PM, Sangeetha <ysndargmail.com> wrote:
> Gosh I wonder
> why mysql does not support SEubqueries.. It just hangs in the copying to tmp
> table status. Atleast I know whats wrong... Thanks very much
It supports them, but won't optimize them well until 5.2. There's
some good info here:
http://www.xaprb.com/blog/2006/04/30/how-to-optimize-subqueries-and-joins-in-mysql/
- Perrin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]