I’ve got a search application which, going off what I’ve read about Sphinx Vs. MySQL Full-text, would perform ALOT better using Sphinx.
Features I need:
Column weighting, e.g.
titleshould carry more weight than
body, MySQL fulltext allows me to do this by using 2 seperate full-text indexes. This is obviously very inefficient. Does sphinx support this?
Scoring and order by relevance. In this application other variables are taken account in the search results, e.g. age, locations etc, all recieve a score and are used in conjuction to the score provided by MySQL full-text to create the final score which the results are ordered by. Would sphinx allow this?
Features I’d like:
- CJK support (I see Sphinx supports unicode, not sure if it recognises CJK glyphs however [beggers can’t be chosers]).
Features I don’t need:
- Real time indexing. As each new row is also placed in the full-text index in mysql it is inefficient… Search index “lag” in relation to database information isn’t a problem. (I like how sphinx works here… how you can run a query after indexing to flag rows, pretty neat!)
Any opinions on Sphinx would be much appreciated!