Full text search help

Discussion in 'PHP' started by tom007, Jan 20, 2007.

0
  1. #1
    hi,

    I have a testing database with 28000 records and video keyword appear in 11000 records....I have FULL text index on three columns title,tags and notes

    but the query is really slow....any help

    select title,tags,link,description MATCH (title,tags,description) AGAINST ('video') AS score from videotable MATCH (title,tags,notes) AGAINST ('video') order by score DESC

    The index works fine and table is small but the query is very slow.........I am very new to full text search
     
    tom007, Jan 20, 2007 IP
  2. projectshifter

    projectshifter Peon

    Messages:
    394
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #2
    How slow are you talking? Running a query on 28k records, and returning 11k of them is going to take some time no matter how you slice it. If it's a search box and it changes all the time not sure how great the performance will be, but if it's something that there are major ones that are always used, you could try doing some method of "caching" commonly used results.
     
    projectshifter, Jan 21, 2007 IP