#34 Use of Binary Search options for Slash?

[Clifton Wood]

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.