SQL 2008 R2 with Full Text Indexing On Causes Exceptionally Slow Trib Search Performance
systems running SQL Server 2008 R2 with full-text indexing implemented
You may experience very slow searches and even timeouts when using Vibe Trib in conjunction with SQL Server 2008 R2 when using Full Text search.
SQL 2008 R2 has problems with full-text and multiple CONTAINS. More than a few people have reported it, and there isn't a good solution available. Microsoft claimed that the issues were fixed in the service pack, but installing it didn't work for me locally or any other people experiencing the same problems.
We recommend the following work-arounds:
- Use the non full-text version if it is not needed. Confirmed to work as expected.
- Move to a database other than SQL 2008 R2. For instance, the searches work fine on SQL 2008.
- Request a patch from firstname.lastname@example.org that limits the full-text search to product data only. This does bypass the search parameters appconfig, but has been shown to solve the problem for most people.