Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2004

    Exclamation Unanswered: FULLTEXT and short strings

    I was getting some flak the other day because my fulltext search wasn't bring up anything for very short strings such as:

    " 20 GB "

    I set my fulltext up for minimum length of 3 and are using BOOLEAN MODE.
    Therefore a search like "100 GB" will only bring up results containing the string "100".
    If I lower the minimum string length threshold to 2 characters will performance suffer?? If so, by how much? My current fulltext and table is:
    Data: 1.5 GB
    Index: 1 GB

    I'm afraid that going to a 2 character minimum will make things deathly slow and eat up too much disk space. Plus, as soon as I reduce the min length to 2, I'm sure I will get flak because a search for "8 GB" will ignore the "8"
    Is there a trick/hack that would work well in this case?
    Such as using temp tables and LIKE % % ?????
    Or a common keyword table reference for short strings???
    Or should I just tell the hecklers that PHP can't do short strings so live with it?

    - John
    Last edited by jvanv8; 02-10-05 at 11:13.

Posting Permissions

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