… relevance. If you sort by relevance and pick up say top 200 hits you will most likely miss newer posts which… issues (even if sphinx was way faster than mysqls own fulltext it still took 16 seconds for the “heavy” search) and that… searches are common but they do exist). A sidenote was that the sphinx I tested was a beta version and that wildcard searches…

… with search engines in default settings which is quite frequently does not require all keywords to present in found message. Sphinx does require that in “match_all” mode. I think relevance ranking and cutting of result set should be performed in search… public, as this would help SEO guys to spam top result pages. Sphinx relevance algorithm is however well visible in the source…

…. Vadim: Darn, what are the odds that mysql will use sphinx as its native fulltext index instead of todays version/edition… benchmark when there were no boolean search available in sphinx, defaulting to SPH_MATCH_ALL) returning top 200 matches): — PROFILE — root: 12.86… through SPH_MATCH_ALL the search still takes several seconds while TBGsearch takes a few milliseconds. The sphinx index takes 648 MB…

… means that also the speed of the search is significally improved since having a search that contains 10 most common words means… down to say 10 * endresult, like if you will return top 200 back to the client the internal processing might use… seconds Sphinx: 16.31 seconds Vectorbased search: 0.06 seconds On xp3200+ windowsbox: Vectorbased search: 0.01 seconds I dont know how sphinx stores…