Query speed, too many joins, need help getting reponse time down

[DwayneL]

Hello there

I have three tables:

table 1: interviewer -> used to store the name of interviewwr
Feilds:
interviewerID int autonumber
FullName text

table 2: show_interviewers -> used to keep track of interviers for shows since there can more then on interviewer

Feilds:
showID int
interviewerID int


table 3: has all of the show information
Feilds:
showID auto number

this is the format i was using for it full text search it works but takes for every

SELECT shows.show_number, shows.length, shows.summary, shows.recorded_date, MATCH (interviewers.FullName) AGAINST('" . $txtInterviewer . "') AS score from shows, show_interviewers, interviewers
WHERE MATCH (interviewers.FullName) AGAINST ('" . $txtInterviewer . "')
AND shows.tapeID = show_interviewers.showID
AND interviewers.interviewerID = show_interviewers.interviewerID";

any ideas

 

[QatQat]

Index your tables


Bye

Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)