Greg Whalin wrote:
Granted, Kevin's tone was a bit harsh, but his sentiments should be
encouraged (frustration w/ a lack of feature). The concept that
people should be happy with what they get for a free product only
serves to keep the quality of free products below what they could be.
It was 1/2 frustration and 1/2 humor.. Then again I have a strange sense
of humor.
I just thing that the MySQL developers are moving really fast and that
their priorities are really wrong on this one.
Again I think that if they're going to wait so long to fix this issue
that they whould remove the feature. Its just going to shoot people in
the foot and claiming that you support subqueries isn't actually correct
since they're not usable.
The performance of sub-queries in mysql when used in an IN() clause is
embarassingly slow. They are in most cases, unusable because they do
not use indexes correctly. This is a legitimate complaint, and one
that I personally hope Mysql looks into and repairs. I echo Kevin's
thoughts and I rarely even have a use for sub-queries (given I got
used to them not being available).
Thanks...
Kevin
--
Use Rojo (RSS/Atom aggregator)! - visit http://rojo.com.
See irc.freenode.net #rojo if you want to chat.
Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html
Kevin A. Burton, Location - San Francisco, CA
AIM/YIM - sfburtonator, Web - http://peerfear.org/
GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]