The amount of time it takes to update records in a text index can be reduced by enabling (turning on) trace flag 11 or trace flag 12, or both:
Enabling trace flag 11 disables Verity collection optimization. This means that Verity does not optimize the text index after you issue sp_text_notify, which is a performance gain. If trace flag 11 is turned off (the default), the Enhanced Full-Text Search engine calls Verity to optimize the text index at the end of sp_text_notify processing, which can delay the completion of sp_text_notify.
With Enhanced Full-Text Search Specialty Data Store, you can use sp_optimize_text_index to optimize a text index at a later time if trace flag 11 is enabled. See sp_optimize_text_index.
Enabling trace flag 12 disables the Enhanced Full-Text Search engine from returning sp_statistics information. If trace flag 12 is turned off (the default), an update statistics command is issued to the Enhanced Full-Text Search engine, which can delay the completion of sp_text_notify.
If updates to the text index occur as often as every few seconds, you may improve performance by disabling the update statistics processing and the Verity optimization, or both, for most of the updates.
Trace flags 11 and 12 can be enabled and disabled interactively using sp_traceon and sp_traceoff in the Enhanced Full-Text Search engine.
