query problem..
i am using mysql 4.0.21. i am having a 5,000 records in an master table. refrence table info is given bellow.
login tbl- 5,000 - records(master table)
education tbl 11,000 - records(ref tbl)
skill tbl 11,000 -records(ref tbl)
project tbl 10,000 - records(ref tbl)
experience tbl 6,000 - records(ref tbl)
so totaly i am having 5 tables. i am want to search a records by particular name, or skill or project name or something else.... i am using the bellow query
select distinct l.resumeid as resumeid,l.dob as dob,l.candname as candname,l.restitle
as restitle ,l.relocateopt as relocateopt,l.fname as fname,l.totalexp as totalexp,
l.phone1type as pt1,l.phone1no as p1,l.phone2type as pt2,l.phone2no as p2,resumestatus
as rstatus,bid as bid,l.pemail as pemail,l.semail as semail from login as l LEFT OUTER
JOIN blacklist ON blacklist.resumeid = l.resumeid and blacklist.rstatus='A' LEFT OUTER
JOIN education as e ON e.resumeid=l.resumeid LEFT OUTER JOIN skill as s ON
l.resumeid=s.resumeid LEFT OUTER JOIN courses as c ON e.courseid=c.courseid LEFT OUTER
JOIN courses as c1 ON e.splid=c1.courseid Where l.candname<>'' and l.keywords like '%fresher%'
or l.candname like '%rajesh%' and s.skilldesc like '%mysql%'.
but the above query takes lot of time to execute some times it was hang. even i am trying in the query browser too. so plz give me some ideas..
regards
rajesh.