Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2007
    Location
    Bangalore India
    Posts
    28

    Unanswered: problem in mysql full text

    Hi,
    I am having huge database which contain more the 70000 records when i use full text its not giving what i am searching for can you guide in it.

    SELECT * FROM table WHERE MATCH(fieldname) AGAINST ('php company') i am not getting results. I have fine tune full text also its not working.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so are you looking for rows with
    php OR company,
    php AND company

    btw 70,000 records is not huge in anybody's terms, Access/JET can handle 100,000's of rows with eases. these days 'huge' databases come in TerraByte sizes...
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Sep 2007
    Location
    Bangalore India
    Posts
    28
    Quote Originally Posted by healdem
    so are you looking for rows with
    php OR company,
    php AND company

    btw 70,000 records is not huge in anybody's terms, Access/JET can handle 100,000's of rows with eases. these days 'huge' databases come in TerraByte sizes...

    Ok tell me i want to get result what i am searching for exmple "php company"its should list all the php company how its possible in mysql full text

  4. #4
    Join Date
    Oct 2009
    Posts
    1

    fulltext in mysql

    Hi, I have no answer for you, but we have quite similar problem few years ago and come to conclusion not to use mysql (version < 5.x) for fulltext search because its
    - horrible slow in searching
    - horrible slow in indexing
    - horrible inconsistent (for the same question different results in two following queries)

    We have decided to use Lucene as base of our own search engine. If you cannot write your own, then you can use Solr and binding for your language to use it. Try to search solr and lucene at google. Both are projects of Apache fnd.

    Good luck,

    Mirek
    Last edited by xmirek; 10-22-09 at 09:46.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •