views:

1547

answers:

7

What is the best full text search alternative to ms sql? (which works with ms sql)

I'm looking for something similar to Lucene and Lucene.NET but without the .NET and Java requirements. I would also like to find a solution that is usable in commercial applications.

+2  A: 

Sphinx is one of the best solutions. It's written in C++ and has amazing performance.

aku
but it's not for ms sql
Brian R. Bondy
Lucene is not for MSSQL either, you can 2 choices: index documents prior passing it to DB or let indexing engine go through DB itself. Sphinx can't crawl MSSQL automatically as far as I know, but it has best indexing performance.
aku
A: 

I second Sphinx, but Lucene is also not so bad despite the Java. :) If you are not dealing with too much data spread out etc., then also look into MySQL's FULLTEXT. We are using it to search across a 20 GB database.

Till
+1  A: 

DT Search is hands down the best search tool I have used. They have a number of solutions available. Their Engine will run on Native Win32, Linux or .NET. It will index pretty much every kind of document you might have (Excel, PDF, Word, etc.) I did some benchmarks comparisons a while ago and it was the easiest to use and had the best performance.

Jim McKeeth
+2  A: 

Take a look at CLucene - It's a well maintained C++ port of java Lucene. It's currently licenced under LGPL and we use it in our commercial application.

Performance is incredible, however you do have to get your head around some of the strange API conventions.

Alan
+1  A: 

One note of caution on Lucene.NET: it tends to lag behind Apache's Java Lucene (the "official" Lucene). Lucene.NET is a port of Java Lucene, and the community around Java Lucene is larger. For obvious reasons, this can sometimes be a problem.

Babak Ghahremanpour
+1  A: 

Solr is based on Lucene, but accessible via HTTP, so it can be used from any platform.

Mauricio Scheffer
+1  A: 

I prefer Xapian - pure C++ Search Engine Library.

Alex Koshelev