May 27, 2005 at 12:45 pm
what does fulltextcatalogproperty(''FTEmailMessage_2'', ''PopulateCompletionAge'') return when change tracking is enabled? anything meaningfull?
it seems to be returning 7am this morning (it's now 2:40pm), but change tracking is successfully indexing new records that come in about every 20 seconds. why isn't
select fulltextcatalogproperty('FTEmailMessage_2', 'PopulateCompletionAge')
returning getdate() - 20 seconds? What's the significance of 7am? where is it getting that time?
May 27, 2005 at 2:18 pm
Maintains a record of the rows that have been modified in a system table, and propagates the changes to the full-text index. You start the change tracking by executing sp_fulltext_table and specify start_change_tracking for the @action parameter. When using change tracking, you also specify when the changes are taken from the history table and populated in the full-text index:
After starting change tracking with start_change_tracking, you can execute sp_fulltext_table specifying start_background_updateindex for the @action parameter. With this option, changes to rows in the table are propagated to the full-text index as they occur.
In this option, all tracked changes are stored in the history, and only propagated to the full-text index when you execute sp_fulltext_table specifying update_index for the @action parameter.
You can use SQL Agent to schedule periodic jobs that execute sp_fulltext_table specifying update_index for the @action parameter. This will propagate all outstanding tracked changes to the index.
It depends on the type of method used above, if you are using Incremental populations, it might have updated @7am in the morning.
May 27, 2005 at 2:21 pm
that's the rub! I'm using "background" (I've been calling it "change tracking" in these threads.)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply