March 12, 2009 at 7:18 pm
Hi,
I've been asked how soon the new infromation from a table becomes available for search in full text catalogs. E.g. a new record gets inserted into a table with full text indexes on. I assume that this happens after the rebuild, but I am not 100% sure. Is this correct?
Thanks.
March 12, 2009 at 7:33 pm
In SQL Server 2000 you must populate the catalog because Full Text is run from the Microsoft search service but in 2005 you have three options automatically Manual and Do not track changes because Full Text is run from the relational engine.
Kind regards,
Gift Peddie
March 12, 2009 at 8:41 pm
This is what I found about "AUTO" option in BOL:
"Although changes can be propagated automatically, these changes may not be reflected immediately in the full-text index."
What is the typical lag for this situation? Seconds, minutes, hours?
March 13, 2009 at 9:13 am
By default, or if you specify CHANGE_TRACKING AUTO, the Full-Text Engine uses automatic population on the full-text index. After the initial full population completes, changes are tracked as data is modified in the base table, and the tracked changes are propagated automatically. The full-text index is updated in the background, however, so propagated changes might not be reflected immediately in the index.
I got the above from the link below so I don't think we can know the time interval because I am assuming it is managed by the relational engine.
http://technet.microsoft.com/en-us/library/ms142575.aspx
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply