From: Orlando Andico <[EMAIL PROTECTED]> On Thu, 10 Oct 2002, Andy Sy wrote: .. > MySQL does integrate with InnoDB nicely as far as I can tell. It's > just that its SQL features are still lacking. It doesn't even > have subqueries yet, for crying out loud! Still, what is already ..
> "subqueries are used by the lazy and the unable to figure out joins." > :) That sounds more like a gross *abuse* of subqueries than a legitimate use. > seriously, subqueries particularly NOT IN type are horrible for > performance (better to use an outer join in such cases). Better yet, > forget about subqueries altogether and learn how to use joins > effectively. There are many situations (and not very complex ones either) for which JOINs are not enough and the lack of subqueries is a real PITA. These are actually illustrated in the MySQL refman which shows some really ugly workarounds. _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
