sql server full text search: Search Availability on RePopulation -- sql server full text search

Re: Search Availability on RePopulation

Hilary Cotter
5/10/2005 12:00:00 AM

sql server full text search:

There is a performance hit. Your query will be done against the old index
and the new indexes as they are built. Over time these new indexes will be
merged into a single index.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Search Availability on RePopulation

Chuck P
5/10/2005 10:16:22 AM

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.