OSEC

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: Rob Wultsch (wultschgmail.com)
Date: Mon Oct 20 2008 - 23:31:05 CDT

On Mon, Oct 20, 2008 at 8:30 PM, Perrin Harkins <perrinelem.com> wrote:

> 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
>

I'm pretty sure 5.2 became 6.0
6.0 is two major versions out
The last major release happened 3 years ago

--
Rob Wultsch