tags:

views:

132

answers:

2
+1  Q: 

Replacements for Full Text Search

I am not a big fan of Full Text search with MSSQL(not sure if there is another) does anyone know of any other options to this?

+6  A: 

Lucene.Net from Apache is worth a look.

After your raw text data has been indexed, you can use Lucene.Net’s API to search this data. Indexing and searching via Lucene.Net’s APIs is easy and yet very powerful.

Demo and Breakdown

cgreeno  2009-03-11 21:58:33
+1! I'm using Lucene.NET to index data in a legacy database and it's working very, very well. Didn't take much to get it working, either.
David Brown  2009-03-11 22:21:04
A: 

There are a few replacements out there. I can't think of the names of any at the moment.

However major improvements were made with Full Text Search in SQL Server 2008. You may want to look into an upgrade to get the speed improvements.

mrdenny  2009-03-31 04:27:24

related questions

Subsonic Vs NHibernate
How to check For File Lock in C# ?
Is nAnt still supported and suitable for .net 3.5/VS2008?
Limit size of Queue<T> in .NET?
Viewstate invalid when using Safari
Free OCR library
Unhandled Exception Handler in .NET 1.1
Localising date format descriptors
Get a new object instance from a Type in C#
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
.NET Testing Framework Advice
Embedded Database for .net that can run off a network
Automatically update version number
Homegrown consumption of web services
How do you migrate a large app from VB6 to VB .net ?
.NET Migrations Engine
Adding Scripting functionality to .NET applications
SQLite and XSD
Floating Point Number parsing: Is there a Catch All algorithm?
How do I programmatically create a PDF in my .NET application?
How do I sync the SVN revision number with my ASP.NET web site?
XSD DataSets and ignoring foreign keys
Anatomy of a "Memory Leak"
Reliable Timer in a Console Application
How do I calculate relative time?