Geek Answers Handbook

Sphinx vs. Search Results Haystack

I was wondering if there is anyone or can point me in the direction of the results of Sphinx performance tests for search compared to Haystack using the Xapian backend. I am mainly interested in full-text search in one field in one table.

Which one will be "faster"? What are the advantages / disadvantages of the transition? Thanks.

+4
source share
2 answers

Sphinx is one of the fastest of them, but the problem with Sphinx is this: updating the index will bring you to the same time as when creating a new index; so if you have a dynamic database and you need to keep the Index up to date, Sphinx is not a good choice and you should go with Xapian or Solr (Lucene)

Speed ​​(request) Sphinx> Lucene> Xapian

consider working with a huge database other than average. you should read about MySQL full-text search, MyISAM, InnoDB, ...

+4
source

The latest version of Sphinx (2.0.3) has real-time indexes.

+1
source

More articles:


All Articles