Want to use Microsoft Full-Text Search

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
Mike718NY
Commodore (COMO)
Commodore (COMO)
Posts: 485
Joined: Wed Jun 18, 2008 5:24 pm

Want to use Microsoft Full-Text Search

Post by Mike718NY » Mon Nov 03, 2008 8:51 am

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?

User avatar
nickc
Captain (CAPT)
Captain (CAPT)
Posts: 276
Joined: Thu Nov 29, 2007 3:48 pm

Re: Want to use Microsoft Full-Text Search

Post by nickc » Mon Nov 03, 2008 10:11 am

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.

Mike718NY
Commodore (COMO)
Commodore (COMO)
Posts: 485
Joined: Wed Jun 18, 2008 5:24 pm

Re: Want to use Microsoft Full-Text Search

Post by Mike718NY » Wed Nov 05, 2008 10:37 am

>> 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.

User avatar
nickc
Captain (CAPT)
Captain (CAPT)
Posts: 276
Joined: Thu Nov 29, 2007 3:48 pm

Re: Want to use Microsoft Full-Text Search

Post by nickc » Wed Nov 05, 2008 6:25 pm

Sorry - controls are part of a pretty extensive rewrite of site navigation/results, and not mine to share.

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Want to use Microsoft Full-Text Search

Post by AbleMods » Thu Nov 06, 2008 1:07 pm

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
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Post Reply