Thanks Greg for the hint but I also wanted to know when is MySQL version 4.1 to be expected to show up in binaries ?
Ahmed ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Ahmed Farouk" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 02, 2003 11:46 PM Subject: Re: subselects > > 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