List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:July 31 2002 9:11pm
Subject:Re: Speed issues...
View as plain text  
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
	dnelson@stripped
Thread
Speed issues...Richard Baskett31 Jul
  • Re: Speed issues...Roger Baklund31 Jul
  • Re: Speed issues...Tod Harter31 Jul
  • Re: Speed issues...Troy Hakala31 Jul
Re: Speed issues...Richard Baskett31 Jul
  • Re: Speed issues...Dan Nelson31 Jul
    • Re: Speed issues...Richard Baskett31 Jul
      • Re: Speed issues...Dan Nelson1 Aug
        • Re: Speed issues...Richard Baskett1 Aug
          • Re: Speed issues...Richard Baskett1 Aug
          • Re: Speed issues...Dan Nelson1 Aug
  • Re: Speed issues...Tod Harter2 Aug