SQL Server Performance

Updating the fulltext index is slow

Discussion in 'Performance Tuning for DBAs' started by humut, Mar 23, 2007.

  1. humut New Member

    Hi
    When inserting into a table using fulltextsearch which tracks changes, the index is not searchable until 20-60 seconds afterwards.
    This is regardless of using update in background or update_index
    Is there any kind of switch to optimize this time?

  2. MohammedU New Member

    I don't think there is any switch which will improve perfomance...it could be resource availability issue...

    Read the followig article...
    http://msdn2.microsoft.com/en-us/library/aa175787(sql.80).aspx


    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page