Jay Blanchard wrote:
> On Wednesday 08 June 2005 11:16 am, you wrote:
>>Thats funny.. looks like it will be added to 5.1.. Dunno why they
>>it is adding a feature..
>>The best open-source database on the market today? Free
>>Constant improvements to database? Free
>>Ability to complain when we don't get what we want? Priceless
> *I* wasnt requesting anything.. So you need to reply to the person who
> complaining in the first place. I just thought it was funny.. Them
> fixing has
> no care in the world in my mind since I never use subqueries..
> So take your comments elsewhere..Or direct them to the right person..
> Easy there boss, I was just responding to the thread and meant no
> offense. I saw the whole thing as funny.
I personally find the idea that just because a product is free that
people are not allowed to, or should not complain when they find
shortcomings in that product, to be more than a bit short sighted. It
is still VERY arguable as to wether Mysql is or is not the best open
source DB on the market today. I am sure the Postgresql people would
not agree, and they could likely make a very compelling argument. If
Mysql wants to have the best product, then they NEED people to use their
product, and to complain when something is not correct. And, they need
to listen to those complaints from their users. For most any large open
source project, there is more of a need for users and testers than there
is for developers. Those people who use the free version of Mysql are
arguably testers (those w/ support contracts are customers, and are
arguably even more entitled to complain).
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.
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).