Databases
StackOverflow2013
Postsdbo
POphp mysql fulltext search: lucene, sphinx, or?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POphp mysql fulltext search: lucene, sphinx, or?
    primarykey
    data
    text
    <p>This is admittedly <em>similar</em> to (but not a duplicate of) <a href="https://stackoverflow.com/questions/737275/pros-cons-of-full-text-search-engine-lucene-sphinx-postgresql-full-text-search">Comparison of full text search engine - Lucene, Sphinx, Postgresql, MySQL?</a>, 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).</p> <p>The setup: Standard LAMP (Mysql 5.0, PHP 5).</p> <p>MySQL: tables are using the InnoDB engine for foreign key constraints</p> <p>We are looking at indexing data, not pages. data to be indexed may be in multiple languages (utf-8 charset)</p> <p>A number of the comparisons I've come across (like <a href="http://blog.evanweaver.com/articles/2008/03/17/rails-search-benchmarks/" rel="nofollow noreferrer">http://blog.evanweaver.com/articles/2008/03/17/rails-search-benchmarks/</a>) 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).</p> <p>Some others I've come across (such as <a href="http://whatstheplot.com/blog/tag/lucene/" rel="nofollow noreferrer">http://whatstheplot.com/blog/tag/lucene/</a> and <a href="http://pagetracer.com/2008/02/15/sphinx-and-lucene-search-engines-first-impressions/" rel="nofollow noreferrer">http://pagetracer.com/2008/02/15/sphinx-and-lucene-search-engines-first-impressions/</a>) provide very different results for performance of the two systems.</p> <p>Also, all but ignored in much of what I've read is <a href="http://xapian.org" rel="nofollow noreferrer">Xapian</a>. Might this be worth consideration as well?</p> <p>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. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USJonathan Fingland
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POphp mysql fulltext search: lucene, sphinx, or?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POphp mysql fulltext search: lucene, sphinx, or?
      1. USItay Moav -Malimovka
      1. VTFavorite
    3. VO
      singulars
      1. POphp mysql fulltext search: lucene, sphinx, or?
      1. USodinho - Velmont
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload