SQL*
SSCertifiable
Points: 6638
More actions
August 30, 2009 at 11:50 pm
#135087
hi,
i recently using Fulltext serch.but it is too slow when i access it.
i'm using free text query for this.
how can i optimize the FULL-TEXT Index query.
how can i remove the catalog and recreate .
please help me.
🙂
SanDiegoBeach
Old Hand
Points: 368
September 1, 2009 at 7:50 am
#1047528
If you are seeing an initial 45 second delay when you perform a search, it may be caused by by SQL Server attempting a file signature verification, but is unable to do so due to firewall settings or lack of Internet Connectivity.
Here is an MS article that deals with this issue.
http://support.microsoft.com/kb/915850/en-us
I have used this solution in the past successfully.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply