From: Jeff Smelser
Date: June 8 2005 4:11pm
Subject: Re: Seriously..  When are we going to get subqueries?!
List-Archive: http://lists.mysql.com/mysql/185172
Message-Id: <200506081111.05281.tradergt@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed;
  boundary="nextPart1140989.rY8B7s5bZj";
  protocol="application/pgp-signature";
  micalg=pgp-sha1
Content-Transfer-Encoding: 7bit

--nextPart1140989.rY8B7s5bZj
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Wednesday 08 June 2005 10:56 am, you wrote:
> In the last episode (Jun 08), Jeff Smelser said:
> > On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote:
> > > Subqueries in 4.1 are totally broken.  They don't use indexes.
> > > They're evil.  We're told we have subqueries but there's no way
> > > anyone on earth could use them.  To make matters worse a lot of
> > > developers are TRICKED into using them and assume that mysql would
> > > do the right thing but its a HUGE performance hit.
> >
> > Well, have you filed a bug? I just looked and didnt see one.. It
> > wouldnt be the first time, however, a bug search function didnt find
> > something that was there..
>
> There are actually quite a few bugs already filed on subquery
> performance: 4975, 7830, 8086, 8414, 9021, 9090, 10309, 10312, 10989,
> from a quick search on "+subquery +index".  Most have been set to "To
> be fixed later".

Thats funny.. looks like it will be added to 5.1.. Dunno why they think fix=
ing=20
it is adding a feature..

Jeff

--nextPart1140989.rY8B7s5bZj
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQBCpxiZoOk9EvUvEtgRAjuVAJ4yaXCTZuUO/wMBJHCczIbk0Kx4DQCgrObC
bo+7P9FihjvPGzCG/GcUjZg=
=Rq5Q
-----END PGP SIGNATURE-----

--nextPart1140989.rY8B7s5bZj--