#34 Use of Binary Search options for Slash?

open
nobody
None
1
2003-09-09
2002-11-22
No

In the later versions of MySQL, there are now binary
search options which can be used to improve searching
for any Slash based site with very simple alterations,
you can find details on MySQL's Binary Searching, here:

http://www.mysql.com/doc/en/Fulltext_Search.html

Particularly, you'd be doing:

MATCH ... AGAINST('$query' IN BOOLEAN MODE)

Instead of thh current:

MATCH ... AGAINST($query)

It could even be an option on the search form that
defaults
to off if performance, as opposed to accuracy is needed.

Discussion

  • Rob Malda

    Rob Malda - 2002-11-26
    • priority: 5 --> 1
     
  • Rob Malda

    Rob Malda - 2003-09-09
    • labels: 310786 -->
     
  • Rob Malda

    Rob Malda - 2003-09-09
    • milestone: 191917 -->
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks