JavaEye3.0 Development Notes Three-the lion body face

The meaning of Sphinx is "Sphinx", is the pyramid architecture of Ancient Egypt, legend Sphinx is winged lion body female strange, she often call passers-by guessing, guess not the person is killed.

But the sphinx I'm talking about here is a high-performance search engine:

http://www.sphinxsearch.com/

Sphinx is a Russian-developed search engine, its main features are:

First, the performance is very good

1.5 million records a two-minute index completed, within the 2-4GB text retrieval speed less than 0.1 seconds. Ferret, not to mention Lucene.

Second, and database integration is very good

Sphinx through the configuration file can read the database information indexed, do not rely on any external applications, and can be launched as a daemon process to support distributed retrieval, concurrent response performance is very good. So many people who used ferret in the past have switched to Sphinx because of concurrent retrieval problems.

Third, can do the full text of MySQL search

MySQL database engine is a pluggable structure, Sphinx developed a SPHINXSE database engine, can be compiled directly into MySQL when compiling MySQL, so that you can support high-performance Full-text search at the database level, then you can use the following SQL Way to the full text search:

SELECT * from xxxx where query= ' test;sort=attr_asc:group_id ' and ...;

It's great.

Four, ROR support is also very good

There is a Acts_as_sphinx plug-in, similar to Acts_as_ferret, integrated into the ROR inside is very simple.

Sphinx Current problems may be estimated or Chinese word segmentation problem:

Sphinx Support UTF-8 encoded participle, but his own document says that only support English and Russian participle, so I estimate that Chinese participle may not be very good support.

In short, Sphinx is another great choice for us.