SQL Server Performance

Search over Text, Is full-text only solution?

Discussion in 'T-SQL Performance Tuning for Developers' started by franjavier, Feb 8, 2003.

  1. franjavier New Member

    We have a web search engine that search in the text on around 50,000 Websites.
    We search the text using SQL server full-text search.
    We've built a ranking system so depending where the string was found, a point is assigned, example if the string was found in title we assign a higer score than if the string was found in the body.

    The results are ok, the problem is wiht the speed, it takes from 5-60 seconds to output the results.

    I don't know if someone could advice us on how to improve speed, is it full-text search the only way to search text?

    Thanks

  2. bradmcgehee New Member

    You can check out a third-party program fromhttp://www.imptechnology.com. They offer an add-on search engine that is very fast. Other than using a third-party product, full-text search is about your only option, unless you want to write your own Transact-SQL, which may or many not be as fast.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com

Share This Page