Sphinx Introduction _php Tutorial

What is full text search?

Full text retrieval is a kind of information retrieval technology which takes all the textual information of the document as the retrieval object. The retrieved object may be the title of the article, or it may be the author of the article, or it may be the article summary or content.

What is Sphinx?

Sphinx is an SQL-based full-text search engine that can be combined with mysql,postgresql for full-text searching, which provides a more specialized search function than the database itself, making it easier for applications to implement specialized full-text searches. Sphinx specifically designed search API interfaces for some scripting languages, such as Php,python,perl,ruby, and also designed a storage engine plugin for MySQL.

Sphinx A single index can contain up to 100 million records, and the query speed of 10 million records is 0.x seconds (milliseconds). Sphinx indexes are created at a rate of 3-4 minutes to create an index of 1 million records, an index to create 10 million records can be completed in 50 minutes, and only an incremental index of the latest 100,000 records is required, only dozens of seconds to rebuild.

Let's look at a more common PHP + MySQL + Sphinx search engine architecture diagram:

What are the characteristics of Sphinx?

High-speed index (on the new CPU, nearly ten MB/s);
High-speed search (the average query speed in the 2-4g text volume is less than 0.1 seconds);
High availability (up to a maximum of 100M documents on a single CPU);
Provide a good relevance ranking
Support distributed search;
Provide document summary generation;
Provides search from a plug-in storage engine inside MySQL
Supports Boolean, phrase, and word proximity queries;
Support for multiple full-text search domains per document (default maximum of 32);
Supports multiple attributes per document;
Support word breaking;
Support single-byte encoding and UTF-8 encoding;
Supports 中文版 stemming, Russian stemming, and Soundex for morphology;
Support MYSQ (MyISAM and InnoDB tables are supported);
Support PostgreSQL.

For more detailed tutorials please refer to: PHP Official Sphinx documentation

Articles you may be interested in

• Sphinx installation under Windows [Support Chinese full text Search]
• Usage and differences in PHP that jump out of multiple loops using Break,continue,goto,return,exit
• How PHP determines whether the current operating system is Linux or Windows
• The usage and difference of echo,print,print_r,var_export,var_dump in PHP
• PHP finds whether a value exists in the array (In_array (), Array_search (), array_key_exists ())
• Implementation of Sphinx Chinese full-Text search
• PHP $this, Static, final, const, self, and several other key words to use
• How to simulate the ping command in PHP

http://www.bkjia.com/PHPjc/764157.html www.bkjia.com true http://www.bkjia.com/PHPjc/764157.html techarticle What is full text search? Full text retrieval is a kind of information retrieval technology which takes all the textual information of the document as the retrieval object. The object retrieved may be the title of the article, or it may be the text ...

