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

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.

主站蜘蛛池模板: 宝鸡市| 饶平县| 石首市| 界首市| 怀柔区| 长汀县| 勐海县| 中卫市| 祁连县| 彝良县| 宁城县| 乃东县| 武功县| 舞阳县| 綦江县| 蒙阴县| 集安市| 平罗县| 南澳县| 海丰县| 安庆市| 疏勒县| 长丰县| 临桂县| 霍州市| 东至县| 滨州市| 渑池县| 义马市| 牡丹江市| 腾冲县| 青海省| 太仆寺旗| 平谷区| 凉城县| 永寿县| 鹿邑县| 舞阳县| 巧家县| 长沙县| 滦南县|