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 fixing it is adding a feature.. Jeff
pgpAsEbArMgRn.pgp
Description: PGP signature
