[thelist] Joining tables... in MySQL
Hassan Schroeder
hassan.schroeder at gmail.com
Wed Apr 4 09:58:43 CDT 2007
On 4/4/07, Jason Handby <jason.handby at corestar.co.uk> wrote:
> > SELECT * FROM jobType, jobs WHERE jobType.id = jobs.jobType
> >
> > /me doesn't understand why so many people try to force themselves into
> > left/inner/right joins when you can just say "where this is that"
>
> Because this join syntax is incredibly out of date, and there are things
> you can't express in it. Much better to get into the habit of using the
> "new" syntax.
And performance --
I recently noticed a fairly complex query with a lot of old 'WHERE this
AND WHERE that' was taking over 30 seconds on MySQL 4.1.x.
Reformulating it to use JOIN syntax brought it down under a second :-)
Small sample, YMMV, etc....
--
Hassan Schroeder ------------------------ hassan.schroeder at gmail.com
More information about the thelist
mailing list