“Generally, it’s a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications.”
(From sphinxsearch.com)
Does this mean that the sphinx engine only should be used when string based searches? Or would it also be able to boost performance of for example “SELECT user_id FROM users WHERE age BETWEEN 20 AND 26 ORDER BY last_login”?
Thanks in advance )