OK...
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.
So...
1. When will subqueries that actually use indexes be implemented?
We've been promised this feature since 4.0.... it was one of the biggest
feature wins of 4.1.
2. If they won't be in 5.0 could you please abandon a feature for 5.0
and concentrate on subqueries?
3. If they won't be in 5.0 could you at least be honest and remove this
feature since in the best case its useless and in the worse case its
dangerous (god forbid someone should ship code that uses this)?
Not trying to be obnoxious here but I really want this feature and the
current implementation is very...... evil.
:)
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]