| Sphinx features [message #206] |
Thu, 28 September 2006 07:27  |
 Speeple
Messages: 91
Registered: August 2006 |
Member |
|
|
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. `title` should 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?
- Boolean queries
- 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!
Martin Gallagher | Speeple: The latest news
|
|
|
Members
Search
Help
Register
Login
Home
