Issue: No resultset for any title search.
When running this query in Query Analyzer, it's returning this error message: Word breaking timed out for the full-text query string. This can happen if the wordbreaker took a long time to process the full-text query string, or if a large number of queries are running on the server. Try running the query again under a lighter load.
exec p_fetch_search_results '"act"', '', 'ACT', '', 0, 2014, 0, 500, 0, 'N', 'N', 'N', 'N', ''
Solution:
SELECT FULLTEXTSERVICEPROPERTY('VerifySignature');
GO
-- if 1, then turn off verify_signature
EXEC sp_fulltext_service 'verify_signature', 0;
GO
Explanation:
If you are running the full text service on SQL Server 2005, a 45 second attempt to verify signature is performed, while your users are waiting for the full text query to return. Since most web page timeouts are ~30 seconds, this causes the page to timeout. See the following link, which recomends 1. Upgrade to SQL Server 2008 2. or Turn off verify signature
No comments:
Post a Comment