Home Choosing a stand-alone full-text search server: Sphinx or SOLR?
Reply: 0

Choosing a stand-alone full-text search server: Sphinx or SOLR?

user10829 Published in September 20, 2018, 12:43 pm

I'm looking for a stand-alone full-text search server with the following properties:

  • Must operate as a stand-alone server that can serve search requests from multiple clients
  • Must be able to do "bulk indexing" by indexing the result of an SQL query: say "SELECT id, text_to_index FROM documents;"
  • Must be free software and must run on Linux with MySQL as the database
  • Must be fast (rules out MySQL's internal full-text search)

The alternatives I've found that have these properties are:

  • Solr (based on Lucene)
  • ElasticSearch (also based on Lucene)
  • Sphinx

My questions:

  • How do they compare?
  • Have I missed any alternatives?
  • I know that each use case is different, but are there certain cases where I would definitely not want to use a certain package?
share|improve this question

closed as not constructive by casperOne Feb 15 '12 at 12:25

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Have you ruled out using straight Lucene? Solr is a service on top of lucene, so straight Lucene could stile be a possibility. – Dave Aug 16 '09 at 12:22
  • Does Lucene have a stand-alone server mode? I thought that was one of the things SOLR added? I haven't ruled out anything - so feel free to advocate Lucene if that is the best choice given the requirements :-) – knorv Aug 16 '09 at 17:30
  • What's your client platform? – Mauricio Scheffer Aug 16 '09 at 20:39
  • mausch: Mainly Java but also other languages. – knorv Aug 16 '09 at 21:48
  • 2
    Have you looked at elasticsearch.com ? – FYA Mar 9 '11 at 17:16

5 Answers 5

active oldest votes
up vote 323 down vote accepted
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.544586 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO