… should be the best printed material about Sphinx out there, though as of now Sphinx has surely grown into the size to…-30% faster when it comes to rare word combinations, while if you search for frequent words the difference can be as large as…. Anyways I’m excited of this new Sphinx milestone, and if you’re using Sphinx, be sure to try this new release…
Comment: Full text search for all MySQL Storage Engines
June 29, 2006 By 37 Comments
… default settings which is quite frequently does not require all keywords to present in found message. Sphinx does require that in “match… ? Different application have different sorting needs – right, this is why sphinx has number of sort mode (and one can add his… would be less handling with less frequent words ? As I understand you still store vector for the word which has bits for every…
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
… frequent keywords can add noise and actually get relevance worse. Looking at alternative solution, which we’re often using with MySQL – Sphinx… in time. From Relevance standpoint “stop words” rarely cause problems with sphinx because it uses word position based ranking not just frequency based…
Comment: Full text search for all MySQL Storage Engines
June 29, 2006 By 37 Comments
… scan it fully if word is frequent or not. This is surely going to be faster if word is frequent (selectivity is low) but…. Now speaking about index sizes – Sphinx always stores word positions which would take over half of the sphinx index. Plus MySQL stores timestamp…. I guess removing them would half index size again. Storage sphinx is using is doclist+hitlist with crc32 used as dictionary…
