• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 278
  • Last Modified:

Large Full text management

I have a database we are porting from Oracle to SQL 2008. One of our tables is 22,000,000 rows of data and need to do a full text index on it.  There are 3-4 fields that need to be part of the index.  I need to do fuzzy logic searching. Ideally, I would like to have a spelling checker, custom stop words and synonym database.  There is between 10K lookups per day returning average of 500 results that will come via .NET web application.  Around 5000 Add/Delete/Updates per day on low side, 10,000 on the high.  

Should I be using SQL 2008 out of the box or look at 3rd party indexer or applications.  I have not had much luck finding expert level articles on how to maximize the Full text index of SQL Server.  Does anyone have more feedback or resources for information.  
0
egarrison
Asked:
egarrison
  • 2
1 Solution
 
Mark WillsTopic AdvisorCommented:
0
 
Mark WillsTopic AdvisorCommented:
Oh, and one more (you could link to from the above) but worth pointing out http://msdn.microsoft.com/en-us/library/cc721269.aspx it talks about new things, but there are a couple of points about performance which should interest you...
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now