Fulltext index creation taking a long time?

Posted on April 23, 2008

0


This may be only relevant to 2008 but if you find Fulltext index creation taking a long time to complete you may be affected by a potential bug in CTP6. If you are experiencing this problem you can try running the following statement prior to the creation of the index. This will disable the checking of the OFFICE filter signature.

sp_fulltext_service
‘verify_signature’, 0

On machines we have here, the signature does not appear to exist for the dll and therefore the crawl is taking a long time to complete.

Advertisements