Re: Help with search performance

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Date: Wed, 22 Dec 2004 12:35:14 -0500

oops, wrong newsgroup. Your FreeText query is probably giving you inaccurate
resuls due to permission or scope problems. Can you post your entire query
here?

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:eXX3IgE6EHA.1404@TK2MSFTNGP11.phx.gbl...
> 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.
> >
> >
> >
>
>