"Ed" <Ed@discussions.microsoft.com> wrote in message
news:986908B8-C0DF-4120-9F53-934FF0EB9889@microsoft.com...
> Hi,
> I would like to know the major difference between Incremenatal Population
> and Track Changing Population. The only difference that I've found is the
> Incremental needs to have a timestamp column in the table. How do I
> decide
> if I should use Incremental or Track Changing? are there any general
> rules?
>
> Thanks
>
> Ed

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:%23%239OfdXDHHA.3660@TK2MSFTNGP06.phx.gbl...
> Change tracking is near real time. So changes which occur in the tables
> you are full-text indexing will appear in the index within seconds
> depending on a few factors (content - XML is very slow, TIFFs are really
> slow), hardware, number of changes, and the load on your SQL Server.
>
> Change tracking can cause locking and fragmentation of your catalog. You
> should run an organize periodically.
>
> Incremental populations are almost as lengthy as full populations, use a
> full-population over an incremental population whenever the majority of
> your database changes at any one time.
>
> Use an incremental population when a large number of rows change in a
> short amount of time, and this large number is not a significant portion
> of your total table.
>
> You will have to study which works best for you on your hardware, your
> data, and your data modification patterns.
>
> --
> 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
>
>
>
> "Ed" <Ed@discussions.microsoft.com> wrote in message
> news:986908B8-C0DF-4120-9F53-934FF0EB9889@microsoft.com...
>> Hi,
>> I would like to know the major difference between Incremenatal
>> Population
>> and Track Changing Population. The only difference that I've found is
>> the
>> Incremental needs to have a timestamp column in the table. How do I
>> decide
>> if I should use Incremental or Track Changing? are there any general
>> rules?
>>
>> Thanks
>>
>> Ed
>
>

"Kyle Jedrusiak" <kjedrusiak@princetoninformation.com> wrote in message
news:efxY2VRUHHA.4828@TK2MSFTNGP05.phx.gbl...
> Was reading your email below.
>
> We're using change tracking.
>
> You say to "run and organize periodically". I'm not sure I know how to do
> this.
>
> Would you point me in the right direction...thanks
>
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:%23%239OfdXDHHA.3660@TK2MSFTNGP06.phx.gbl...
>> Change tracking is near real time. So changes which occur in the tables
>> you are full-text indexing will appear in the index within seconds
>> depending on a few factors (content - XML is very slow, TIFFs are really
>> slow), hardware, number of changes, and the load on your SQL Server.
>>
>> Change tracking can cause locking and fragmentation of your catalog. You
>> should run an organize periodically.
>>
>> Incremental populations are almost as lengthy as full populations, use a
>> full-population over an incremental population whenever the majority of
>> your database changes at any one time.
>>
>> Use an incremental population when a large number of rows change in a
>> short amount of time, and this large number is not a significant portion
>> of your total table.
>>
>> You will have to study which works best for you on your hardware, your
>> data, and your data modification patterns.
>>
>> --
>> 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
>>
>>
>>
>> "Ed" <Ed@discussions.microsoft.com> wrote in message
>> news:986908B8-C0DF-4120-9F53-934FF0EB9889@microsoft.com...
>>> Hi,
>>> I would like to know the major difference between Incremenatal
>>> Population
>>> and Track Changing Population. The only difference that I've found is
>>> the
>>> Incremental needs to have a timestamp column in the table. How do I
>>> decide
>>> if I should use Incremental or Track Changing? are there any general
>>> rules?
>>>
>>> Thanks
>>>
>>> Ed
>>
>>
>
>