How's your application written? i.e. J2EE? We've managed to put a layer in between the application and MySql that translates subselects on the fly into inner joins.
This allowed us to quite painlessly move from MS SQL to MySql. "EXISTS" can be refactored into an inner join. "NOT EXISTS" can be refactored into an outer join with test for null on an outer joined column. Of course we'll rip this layer out when subselects are available but the tradeoff is we don't have to spend $10K per server for licensing, and even with this translation layer in, it's still faster than MS SQL. Greg > > From: "Ahmed Farouk" <[EMAIL PROTECTED]> > Subject: subselects > Date: 03/01/2003 6:01:00 > To: <[EMAIL PROTECTED]> > > Hi All > I know that this maybe a repeated question here but I just need to know > the updates. > I am asking about the new feature of subselects which should be implemented > in version 4.1 (thats what i know), when this version is expected to the > light ? > > For me this single feature (subselect) will enable our company to transfer > many applications from Oracle to MySQL and I think the same holds for many > people out there so we are really eager to see it working. > > > Thanks > Ahmed Farouk > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > This message was sent through MyMail http://www.mymail.com.au --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php