News for hackers. Stuff that matters.
Re:A fast, fuzzy, full-text index using Redis by donw on Wednesday May 05, 2010 @02:07PM (#1321959)
If you're going to look at Sphinx, you'd do yourself a disservice by not also looking at Solr.

Solr has effectively the same feature set, including geospatial and multilingual searching, but it has better relevance, and generally is faster at returning query results (although Sphinx is faster at doing full reindexes).

Also, unlike Sphinx, Solr doesn't glue you to MySQL. Or to any SQL database; use it with Cassandra, Voldemort, text files, quantum storage in the galactic hive-mind, whatever.

(edit: They've added PostgreSQL support, and raw XML support, since I last installed and tested Sphinx about a year ago)

Plus, unlike Sphinx, you don't need to reindex when you add new records, because Solr can seamlessly merge indexes on-the-fly.

I know I sound like a fanboy here, but I spent a lot of time evaluating the two of them for our product, and Sphinx just didn't fit the bill for a large number of reasons. It's a good solution if you just need fulltext indexing in a MySQL database, but if you want to move beyond that, have a look at Solr.

http://beerpla.net/2009/09/03/comparison-between-solr-and-sp...

Re:A fast, fuzzy, full-text index using Redis by petercooper on Wednesday May 05, 2010 @03:40PM (#1322281)
Or, if you don't want yet another daemon, Xapian. It's almost the SQLite of full text searching. Has its limits, but is crazy fast and scales well.
Re:A fast, fuzzy, full-text index using Redis by jawngee on Wednesday May 05, 2010 @05:26PM (#1322642)
+1 for Solr.

We're replacing our text indexing solution with Solr and it's been a phenomenal transition.