Sphinx is a SQL-based full-text search engine that can be combined with MySQL and PostgreSQL for full-text search. It can provide more professional search functions than the database itself, making it easier for applications to implement professional full-text search. Sphinx specially designs search API interfaces for some scripting languages, such as PHP, Python, Perl, Ruby, etc., and also designs a storage engine plug-in for MySQL.
A single Sphinx index can contain up to 100 million records, and the query speed for 10 million records is 0.x seconds (milliseconds). The speed of index creation by Sphinx is: it only takes 3 to 4 minutes to create an index of 1 million records, and it can be completed in 50 minutes to create an index of 10 million records. An incremental index containing only the latest 100,000 records needs to be rebuilt once. It only takes tens of seconds.
Expand
