2012年3月22日星期四

Full Text Search Availability

If I have a table with a Full Text Search and I do a Full Re-Population
What happens if someone does a Search while it is doing a Full Repopulation?
Is the search delayed until the repopulation is done,
does it only search the rows that have been populated,
does it timeout/error?
something completely different?
My desire is to have 7x24 searching available, even when massive changes
occur to the indexed table each night.Chuck,
I don't know the answer for sure but you should really ask this in the FTS
news group to have a better chance of a proper answer.
--
Andrew J. Kelly SQL MVP
"Chuck P" <nospam@.crlf.com> wrote in message
news:DFDB6653-165C-4720-A04E-D1C394AE1C00@.microsoft.com...
> If I have a table with a Full Text Search and I do a Full Re-Population
> What happens if someone does a Search while it is doing a Full
> Repopulation?
> Is the search delayed until the repopulation is done,
> does it only search the rows that have been populated,
> does it timeout/error?
> something completely different?
> My desire is to have 7x24 searching available, even when massive changes
> occur to the indexed table each night.

没有评论:

发表评论