- Sphinx Search Beginner's Guide
- Abbas Ali
- 312字
- 2021-04-09 21:30:56
If you're looking for a good Database Management System (DBMS), there are plenty of options available with support for full-text indexing and searches, such as MySQL, PostgreSQL, and SQL Server. There are also external full-text search engines, such as Lucene and Solr. Let's see the advantages of using Sphinx over the DBMS's full-text searching capabilities and other external search engines:
- It has a higher indexing speed. It is 50 to 100 times faster than MySQL FULLTEXT and 4 to 10 times faster than other external search engines.
- It also has higher searching speed since it depends heavily on the mode, Boolean vs. phrase, and additional processing. It is up to 500 times faster than MySQL FULLTEXT in cases involving a large result set with GROUP BY. It is more than two times faster in searching than other external search engines available.
- As mentioned earlier, relevancy is among the key features one expects when using a search engine, and Sphinx performs very well in this area. It has phrase-based ranking in addition to classic statistical BM25 ranking.
- Last but not the least, Sphinx has better scalability. It can be scaled vertically (utilizing many CPUs, many HDDs) or horizontally (utilizing many servers), and this comes out of the box with Sphinx. One of the biggest known Sphinx cluster has over 3 billion records with more than 2 terabytes of size.
In one of his presentations, Andrew Aksyonoff (creator of Sphinx) presented the following benchmarking results. Approximately 3.5 Million records with around 5 GB of text were used for the purpose.

Apart from a basic search, there are many features that make Sphinx a better solution for searching. These features include multivalve attributes, tokenizing settings, wordforms, HTML processing, geosearching, ranking, and many others. We will be taking a more elaborate look at some of these features in later chapters.
- iPad+Procreate數(shù)字插畫設(shè)計(jì)案例教程(全彩微課版)
- Blender 3D 2.49 Architecture, Buidlings, and Scenery
- Google Web Toolkit 2 Application Development Cookbook
- Illustrator CC 2018中文版入門與提高
- 新編AutoCAD 2016從入門到精通
- 從零開始:Photoshop工具詳解與實(shí)戰(zhàn)
- MATLAB 2022a從入門到精通
- UI功夫:PC和APP界面設(shè)計(jì)全流程圖解
- Oracle Enterprise Manager Grid Control 11g R1: Business Service Management
- 正則表達(dá)式必知必會(huì)(修訂版)
- Plone 3 for Education
- AI繪畫基礎(chǔ)與商業(yè)實(shí)戰(zhàn)
- MATLAB在日常計(jì)算中的應(yīng)用
- SEO搜索引擎優(yōu)化:基礎(chǔ)、案例與實(shí)戰(zhàn)(第2版)
- Business Process Driven SOA using BPMN and BPEL