In the last episode (Jul 31), Richard Baskett said:
> Ok I've Analyzed each table and it looks like it has cut around 20 seconds
> off of the average time.
>
> Im trying to figure out how I can take out the left joins.. I need
> some of that data to be displayed to the user.. Would it be quicker
> to get rid of the location and category left join and then for every
> displayed record find the location that corresponds with that
> Location ID in the main query? That seems like a whole lot of hits
> on the database...
Explain exactly why you need a left join at all. You should be able to
use a regular inner join, as long as all your fields are populated. If
none of your Job records have NULL LocID and CatID fields, your outer
joins are simply hindering mysql's ability to optimize the query.
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
