Re: incremental change tracking

From: "Jean-Pierre Riehl" <jean-pierre.riehl@xxxxxxxxxxxxxx>
Date: Tue, 7 Aug 2007 22:49:24 +0200

Hi Jack,

Change Tracking involves a small latency. The more updates there is, the longer latency is.
You cannot control how changes propagate in Full-Text index except using Incremental population.

--
Jean-Pierre Riehl
http://blog.djeepy1.net
http://www.bewise.fr

"Jack Vamvas" <DEL_TO_REPLY@xxxxxxx> wrote in message news:5YKdnSu6OJlXvCXbRVnyigA@xxxxxxxxx

I have a SQL 2000 full text catalog with Incremental population and Change Tracking.
There is a replication job on the table , which replicates every 10 minutes.
Sometimes there is a delay from the time the data appears in the table , to the point it appears in Full text catalog.

Is there a built - in mechanism where the indexing won't occur until CPU use drops down to a certain level?

--

Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com

References:
- incremental change tracking
  - From: Jack Vamvas

Prev by Date: Re: Fulltext search too slow
Next by Date: Re: Too many full-text columns or the full-text query is too compl
Previous by thread: incremental change tracking
Next by thread: Re: incremental change tracking
Index(es):
- Date
- Thread