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

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.

主站蜘蛛池模板: 大关县| 图们市| 吉安市| 瑞安市| 郁南县| 丁青县| 乐至县| 临武县| 揭西县| 临朐县| 崇左市| 浦北县| 西昌市| 新闻| 胶南市| 托克逊县| 九台市| 栾川县| 江门市| 无锡市| 古交市| 阳高县| 山阳县| 沐川县| 绥芬河市| 南川市| 平凉市| 黑河市| 德令哈市| 色达县| 固阳县| 郴州市| 基隆市| 论坛| 公主岭市| 丰都县| 辽宁省| 景谷| 龙口市| 泸定县| 平罗县|