Full Text serch is very slow

• Dipesh Neema

  SSC Rookie

  Points: 28

  More actions

  December 2, 2010 at 3:03 am

  #388352

  I am having a table with 5 million records. I have fields (Title,AuthorList) as fulltext columns.

  When I search uncommon words it gives results fast but when i used Contains((PRODUCT_TITLE,AuthorList ),'"john"') then it took around 2 mins to return 200,000 records.

  How can i fast the search.

• magasvs

  SSCertifiable

  Points: 7660

  More actions

  December 18, 2010 at 11:49 am

  #1264386

  The first step will be defragment the index of the base table. More information could be found heer: http://msdn.microsoft.com/en-US/library/ms142560(v=SQL.90).aspx (look at the last part of the article).