With the efficiency comment below, I was using the strategy that I'd prefer to wait for 4.1's impending (?) release rather than rewrite SQL in a workaround way. It's a tradeoff based on our specific project and relating to time factors, etc, and the amount of SQL I'd have to rewrite.
Yes i'm sure the hurdle could be overcome but I'd rather hold back on MySql support until subselect functionality is ready. Typically, database vendors seem to recommend using EXISTS because the query returns on finding the first row that meets whatever the subselect criteria is. Do those people working on 4.1 anticipate the performance of the MySql sub select functionality to be better than an equivalent query written as a join? I guess any answer to this should also include consideration of sometimes putting DISTINCT in the select statement. Thanks a lot, Greg. ----- Original Message ----- From: "Michael T. Babcock" <[EMAIL PROTECTED]> To: "Greg Matthews" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, November 11, 2002 11:16 AM Subject: Re: MySql 4.1 Sub Selects > Greg Matthews wrote: > > >clause) instead of EXISTS -- seems like a "tail wagging the dog" strategy. > >Isn't EXISTS a lot more efficient than an inner join? > > > > Well, its more efficient if it exists, I guess ... but if it doesn't > exist on your platform (MySQL), then its pretty inefficient, really. > > >We're going to offering the application on Oracle and so I wouldn't like to > >de-optimize the SQL just so it works on mysql 4.0 if 4.1 will be out within > >a few months. > > > > If you're writing OO code, you might be able to easily flag your objects > as to whether to use one or the other query based on the underlying > database system (queried at run-time). > > -- > Michael T. Babcock > C.T.O., FibreSpeed Ltd. > http://www.fibrespeed.net/~mbabcock > > --------------------------------------------------------------------- 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
