Re: Help with search performance

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 12/22/04 

Date: Wed, 22 Dec 2004 12:02:31 -0500

SQL FTS should give faster results than using a like and the accuracy should
be the same. FreeText is considered to be a more natural way to search as it
searches not only on the term, but the singular/plural form of the word, and
expands the term(s) for all verb forms.

I am wondering if perhaps you indexing has completed successfully. Can you
review the application log using EventVwr and look for messages MSSCi
indicating the status of your population?

"Bill" <msgdev@hotmail.com> wrote in message
news:OYxItZE6EHA.128@TK2MSFTNGP15.phx.gbl...
> I am using indexing server to index files on my computer and I am
searching
> them using ASP.Net. When I use the FREETEXT SQL command the searches are
> very fast but find almost no results. When I use, "Like '%<keyword>%'",
it
> finds the correct results but is very slow. I am new to this so can any
one
> give me suggestions on how to get the performance of a freetext search
with
> the accuracy of a like statement?
>
> Also indexing server does not seem to use up 100% of the CPU it only uses
> about 10%-30%. I want to get the results as fast as possible. I have
> indexing servers set up as dedicated but it still will not use any more
CPU.
>
> Thanks for any help.
>
>
>