<small id='la0Oi'></small><noframes id='la0Oi'>

<tfoot id='la0Oi'></tfoot>

  1. <legend id='la0Oi'><style id='la0Oi'><dir id='la0Oi'><q id='la0Oi'></q></dir></style></legend>
    1. <i id='la0Oi'><tr id='la0Oi'><dt id='la0Oi'><q id='la0Oi'><span id='la0Oi'><b id='la0Oi'><form id='la0Oi'><ins id='la0Oi'></ins><ul id='la0Oi'></ul><sub id='la0Oi'></sub></form><legend id='la0Oi'></legend><bdo id='la0Oi'><pre id='la0Oi'><center id='la0Oi'></center></pre></bdo></b><th id='la0Oi'></th></span></q></dt></tr></i><div id='la0Oi'><tfoot id='la0Oi'></tfoot><dl id='la0Oi'><fieldset id='la0Oi'></fieldset></dl></div>

        <bdo id='la0Oi'></bdo><ul id='la0Oi'></ul>
    2. php mysql全文搜索:lucene,sphinx,还是?

      php mysql fulltext search: lucene, sphinx, or?(php mysql全文搜索:lucene,sphinx,还是?)

    3. <small id='3Uhp6'></small><noframes id='3Uhp6'>

      <i id='3Uhp6'><tr id='3Uhp6'><dt id='3Uhp6'><q id='3Uhp6'><span id='3Uhp6'><b id='3Uhp6'><form id='3Uhp6'><ins id='3Uhp6'></ins><ul id='3Uhp6'></ul><sub id='3Uhp6'></sub></form><legend id='3Uhp6'></legend><bdo id='3Uhp6'><pre id='3Uhp6'><center id='3Uhp6'></center></pre></bdo></b><th id='3Uhp6'></th></span></q></dt></tr></i><div id='3Uhp6'><tfoot id='3Uhp6'></tfoot><dl id='3Uhp6'><fieldset id='3Uhp6'></fieldset></dl></div>

          <legend id='3Uhp6'><style id='3Uhp6'><dir id='3Uhp6'><q id='3Uhp6'></q></dir></style></legend>
            <tbody id='3Uhp6'></tbody>
            1. <tfoot id='3Uhp6'></tfoot>
                <bdo id='3Uhp6'></bdo><ul id='3Uhp6'></ul>

                本文介绍了php mysql全文搜索:lucene,sphinx,还是?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                问题描述

                诚然类似(但不重复)全文搜索引擎的比较 - Lucene、Sphinx、Postgresql、MySQL?,但是我正在寻找的是具体的、受支持的、来自受益于多个可用系统的经验(似乎有很多:我使用过 lucene,但没有使用 sphinx",反之亦然).

                This is admittedly similar to (but not a duplicate of) Comparison of full text search engine - Lucene, Sphinx, Postgresql, MySQL?, however what I am looking for are specific, supported, recommendations from the benefit of experience with more than one of the available systems (there seems to be a lot of: "I've used lucene, but not sphinx", and vice a versa).

                设置:标准 LAMP(Mysql 5.0、PHP 5).

                The setup: Standard LAMP (Mysql 5.0, PHP 5).

                MySQL:表使用 InnoDB 引擎进行外键约束

                MySQL: tables are using the InnoDB engine for foreign key constraints

                我们正在查看索引数据,而不是页面.要索引的数据可能是多种语言(utf-8 字符集)

                We are looking at indexing data, not pages. data to be indexed may be in multiple languages (utf-8 charset)

                我遇到的一些比较(例如 http://blog.evanweaver.com/articles/2008/03/17/rails-search-benchmarks/) 要么不完全适用(ferret 是一个 lucene 端口,但与 Zend_Search_Lucene 不同)或他们正在推动自己的系统/实施(并非完全公正).

                A number of the comparisons I've come across (like http://blog.evanweaver.com/articles/2008/03/17/rails-search-benchmarks/) are either not entirely applicable (ferret is a lucene port but not the same as Zend_Search_Lucene) or they are pushing their own systems/implementations (not exactly unbiased).

                我遇到的其他一些(例如 http://whatstheplot.com/blog/标签/lucene/ 和 http://pagetracer.com/2008/02/15/sphinx-and-lucene-search-engines-first-impressions/)为这两个系统的性能提供了截然不同的结果.

                Some others I've come across (such as http://whatstheplot.com/blog/tag/lucene/ and http://pagetracer.com/2008/02/15/sphinx-and-lucene-search-engines-first-impressions/) provide very different results for performance of the two systems.

                另外,在我读过的大部分内容中几乎被忽略的是 Xapian.这也值得考虑吗?

                Also, all but ignored in much of what I've read is Xapian. Might this be worth consideration as well?

                所以...我希望你们这里的一些人对这个问题有一些经验,可以帮助提出一些建议或为我指明正确的方向.

                So... I'm hoping that some of you here on SO have some experience with this question and could help with some recommendations or point me in the right direction.

                推荐答案

                Sphinx 的一个优点是您可以在客户端和 MySQL 服务器之间插入"它,它只会干扰"专门针对它的查询,透明地将其他人从 MySQL 中反弹——参见例如 这篇文章.无论这是否是您的用例中的优势,您都可以说!

                One advantage of Sphinx is that you can "interpose" it between your clients and the MySQL server, and it will only "interfere" on queries specifically addressing it, transparently bouncing the others off MySQL -- see e.g this article. Whether that's an advantage in your use case, you're best placed to say!

                抱歉,没有使用 Xapian 或 Lucene 的实际经验——尽管如此,阅读有关如何部署它们的信息,听起来(对我来说!)好像只有在您发现实质性优势时才值得.否则,Sphinx 的简单易用"部署,作为您的客户端和 MySQL 服务器之间的代理",对我来说就像是一个巨大的、实质性的胜利!

                Sorry, no real-life experience with Xapian or Lucene -- still, reading about how to deploy them, makes it sound like (to me!) as if it might be worth it only if you identified substantial advantages. Otherwise, Sphinx's "easy as pie" deployment, as a "proxy" between your clients and your MySQL server, feels like a big, substantial win to me!

                这篇关于php mysql全文搜索:lucene,sphinx,还是?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                相关文档推荐

                How do I parse XML containing custom namespaces using SimpleXML?(如何使用 SimpleXML 解析包含自定义命名空间的 XML?)
                SimpleXML SOAP response Namespace issues(SimpleXML SOAP 响应命名空间问题)
                Problems with PHP namespaces and built-in classes, how to fix?(PHP 命名空间和内置类的问题,如何解决?)
                Use php namespace inside function(在函数内部使用 php 命名空间)
                unexpected #39;use#39; (T_USE) when trying to use composer(尝试使用作曲家时意外的“使用(T_USE))
                PHP adding custom namespace using autoloader from composer(PHP使用来自作曲家的自动加载器添加自定义命名空间)
                <legend id='58PtN'><style id='58PtN'><dir id='58PtN'><q id='58PtN'></q></dir></style></legend>
                      <tbody id='58PtN'></tbody>

                    1. <i id='58PtN'><tr id='58PtN'><dt id='58PtN'><q id='58PtN'><span id='58PtN'><b id='58PtN'><form id='58PtN'><ins id='58PtN'></ins><ul id='58PtN'></ul><sub id='58PtN'></sub></form><legend id='58PtN'></legend><bdo id='58PtN'><pre id='58PtN'><center id='58PtN'></center></pre></bdo></b><th id='58PtN'></th></span></q></dt></tr></i><div id='58PtN'><tfoot id='58PtN'></tfoot><dl id='58PtN'><fieldset id='58PtN'></fieldset></dl></div>

                        <small id='58PtN'></small><noframes id='58PtN'>

                          <bdo id='58PtN'></bdo><ul id='58PtN'></ul>
                          <tfoot id='58PtN'></tfoot>