2012年3月21日星期三

Full Text Search

I am using Sql Server 2000 and am using Full Text Search.
There have been some questions on how it works as far as latency of the
data.
We need to be pretty up to date and the records change quite often. Is this
a problem with Full Text? My boss doesn't want it to be an hour behind,
which was what I was looking at setting the repopulation at. I was looking
at running an incremental population every 5 minutes.
Would I ever need to do a full population if I am doing the incrementals all
the time?
How much of a load does it put on the system running it this way?
Thanks,
TomYou might ask this in the .fulltext group as well (if you haven't already).
Meanwhile - look at "change tracking" in Books Online.
The use of full-text services in SQL should be well planned. You need to be
very familiar with the types of text data you'll be supporting, the size of
text data and whether using regular indexes may help you achieve your goal a
t
least in part.
ML
http://milambda.blogspot.com/

没有评论:

发表评论