官术网_书友最值得收藏!

Summary

In this chapter:

  • We learned how to check whether Sphinx was installed properly or not. We saw the directory structure Sphinx creates to store its binary files, configuration files, and other data.
  • We then learned what full-text search is and what its advantages over normal search are. We also saw how full-text search has been implemented in MySQL with an example. We saw the syntax of an SQL query used to search a full-text indexed field in MySQL.
  • We have also seen why to use Sphinx, an external search engine, instead of database's native full-text support. We saw how Sphinx excels in many ways, and outperforms most of the databases and external search engines available today.
  • Lastly we saw how to create an index using the indexer utility, and then how to search that index from the command line as well as other applications using client API implementations.

Having armed ourselves with all the basics we need to know, we are ready to start creating indexes with more options available to us.

主站蜘蛛池模板: 台湾省| 古蔺县| 开原市| 奉化市| 九台市| 陵水| 陆丰市| 峨山| 鹤壁市| 峨眉山市| 道真| 亚东县| 泊头市| 镇江市| 新化县| 凤凰县| 雅江县| 柞水县| 三都| 余庆县| 工布江达县| 永吉县| 芒康县| 仁化县| 正安县| 宝兴县| 那坡县| 开封市| 甘洛县| 南乐县| 大荔县| 民权县| 东丽区| 全州县| 平罗县| 梅州市| 乐昌市| 屯留县| 阿图什市| 清徐县| 荆门市|