Greg Matthews wrote:
Well, its more efficient if it exists, I guess ... but if it doesn't exist on your platform (MySQL), then its pretty inefficient, really.clause) instead of EXISTS -- seems like a "tail wagging the dog" strategy. Isn't EXISTS a lot more efficient than an inner join?
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).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.
--
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
