Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Sphinx - only for string based search?

razdamanrazdaman ContributorInactive User Role Beginner
"Generally, it's a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications."

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 )


  • debugdebug Contributor Current User Role Beginner
    Sphinx is a full-text search engine, not SQL server ) It can't speed up such queries.
  • razdamanrazdaman Contributor Inactive User Role Beginner
    That was what I thought.

    Thanks for the "confirmation"! cool:
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.