On Mon, Aug 27, 2012 at 9:02 PM, Kamal Palei palei.kamal@gmail.com wrote:
Hi All As I will be first time implementing searching stuff , need some guidance from you.
My requirement is I need to search key words from tables, or from files stored in web server. When I was seraching in google, came across SOLR and Sphinx.
I hope both SOLR and Sphinx can support searching from tables as well as from file contents. Please correct me if I am wrong in above assumption. Also I assume both SOLR and Sphinx both have capability to do a full text search, do search for misspelled words etc.
Which one is easy to integrate with Drupal 6?
I have only ever used Solr, but Sphinx does seem awesome in some respects. But, if you are planning on indexing file contents, Solr may be the better option for you. It certainly seems easier to achieve that feature in Solr than Sphinx, depending what sort of documents you are talking about:
http://stackoverflow.com/questions/1207995/indexing-word-documents-and-pdfs-...
FWIW, here's a module that would help you to search documents in Drupal:
http://drupal.org/project/apachesolr_attachments
Yes, Solr handles/helps with misspelled words (http://wiki.apache.org/solr/SpellCheckComponent). And beyond that, pretty much all indexers take words from your content and try to reduce them down to more basic forms so that searches for plural words (cats) also finds the singular form (cat). This is done through a process known as "Stemming" http://en.wikipedia.org/wiki/Stemming.
Some much more complete Solr vs Sphinx round-ups:
http://www.quora.com/How-do-Solr-Lucene-and-Sphinx-compare http://stackoverflow.com/questions/1284083/choosing-a-stand-alone-full-text-... http://beerpla.net/2009/09/03/comparison-between-solr-and-sphinx-search-serv...
Best of luck. -Chad
Best Regards Kamal NECS, Bangalore
-- [ Drupal support list | http://lists.drupal.org/ ]