How to use sphinx technology in our PHP development?
Answer: Corresponding to the fields in the MySQL database, it is to split the Chinese information in the field into multiple words, and then index these words. When querying in the future, first query these index files, then return the primary key IDs of the records that meet the conditions, and then query the MySQL database based on the primary key IDs to return the records.
What is sphinx? (Baidu Encyclopedia)
Note: For sphinx, if there are tens of millions of records in a single table, the response time is at the millisecond level.
Note: By default sphinx only supports English and Russian
Official website:
http://sphinxsearch.com/
Since Sphinx only supports the above two languages, a third-party company has developed a middle segmentation package for sphinx called coreseek
Official website:
http://www.coreseek.cn/
Customer case: http://www.coreseek.cn/products/ft_powered/
Note two points: