Search for article in php

Question

I use sphinx as a search engine on my website, working fine and I am not complaining about it. The only thing he lacks is that it does not allow me to search for articles whose query length is more than 15 words. I know that in fact people don’t use more than 3-4 words that I want to use to search for duplicate content.

I was wondering if there is an alternative solution for the sphinxes. I want to deal with duplicate content.

My main article is in innodb, but I also cache articles in the MyISAM table, as well as for full-text search, but when I search for an article, it takes a lot of time to perform a single search. This is not a query problem, I think mysql does not have the ability to search full-text search.

Thanks jason

Answer 1

Apache Solr is an alternative. It is based on the Apache Lucene project ...

you can check out lucene .

And since you are using MySQL, check out the full-text search. MySQL full-text search

Answer 2

Check also Zend_Search_Lucene: http://framework.zend.com/manual/en/zend.search.lucene.html

Although it is slower than the sphinx.

Answer 3

This may not be useful, but can you just add a unique index to the MySQL field to prevent duplicates from being inserted?

I did not encounter restrictions on the length of the request in the version of Sphinx that I used (0.9.9), but maybe I did not try very hard.