will 4.1 hopefully have stored procedure functionality ? >===== Original Message From "Greg Matthews" <[EMAIL PROTECTED]> ===== >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
--------------------------------------------------------------------- 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