* Richard Baskett
> This is my first post here.. So be nice! ;)
> I have a database with a little over 60,000 records and when I do a search
> on that db it takes a little over a minute and a half to return results.
That sounds slow, yes.
> This is very unacceptable, but Im just not sure what I can do to remedy
> this. Here is what the query looks like when just using location and
> category in the search..
> SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job,
> Company AS
> Comp, Jobs.JobID, Employers.EmpID
> FROM Employers
> LEFT JOIN Jobs USING (EmpID)
> LEFT JOIN JobsLocation USING (JobID)
> LEFT JOIN Location USING (LocID)
> LEFT JOIN JobsCategory ON Jobs.JobID=JobsCategory.JobID
> LEFT JOIN Category USING (CatID)
> WHERE Valid = '1' AND JobTitle IS NOT NULL
> AND (LocName LIKE 'US-Alabama-Birmingham%')
> AND Category.CatID IN ('2')
> ORDER BY Loc ASC LIMIT 0,50
> Add on the following when using keywords in the search, these are the jobs
> to search in since these had the keywords within them:
> AND Jobs.JobID IN ('2345','6578')
Show us the output of "EXPLAIN SELECT ...".
<URL: http://www.mysql.com/doc/E/X/EXPLAIN.html >