Page 1 of 1

Want to use Microsoft Full-Text Search

Posted: Mon Nov 03, 2008 8:51 am
by Mike718NY
I really want to change the Search to use Microsoft Full-Text Search.
It gives much better results.

Someone on here said they did it, but they have the source code, . . I don't.
viewtopic.php?f=45&t=8644&p=37152&hilit ... rch#p37152

Is there anyway to add it without having the source code?

Re: Want to use Microsoft Full-Text Search

Posted: Mon Nov 03, 2008 10:11 am
by nickc
Yes, I'm doing this without source; but you have to write your own search control, results control. FTS is also greatly enhanced if you cache the most recent/popular search results.

Re: Want to use Microsoft Full-Text Search

Posted: Wed Nov 05, 2008 10:37 am
by Mike718NY
>> but you have to write your own search control, results control.

Could I ask you a big favor and take a look at what you have coded?
I all also be happy to share anything that I come up with when I
start working on this. I have used FTS before and it works great.

On this website, http://www.dcp3.com, I used it. It is good because it
searches by word inflections (different forms of the same word).
If you search "women" it will also return results for "Women's ".
It also brings the most relevant matches to the top, like "Baptismal Stationary",
(but I customized the SQL to do that better).

On thing I don't like about the current search is that if your reverse
the search order of the words, it won't bring up any results. But with FTS,
"Stationary Baptismal" will return the exact same results.

Re: Want to use Microsoft Full-Text Search

Posted: Wed Nov 05, 2008 6:25 pm
by nickc
Sorry - controls are part of a pretty extensive rewrite of site navigation/results, and not mine to share.

Re: Want to use Microsoft Full-Text Search

Posted: Thu Nov 06, 2008 1:07 pm
by AbleMods
nickc wrote:Sorry - controls are part of a pretty extensive rewrite of site navigation/results, and not mine to share.
We won't tell :P