Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What are the pros/cons of using the Sphinx Storage Engine in MySQL (doc) over the normal api?

share|improve this question
up vote 5 down vote accepted


  • If there is no Sphinx API for the language you are using SphinxSE allows you to do searches through MySQL.
  • If you are doing background processing and storing the search results in your database SphinxSE allows you to move the data from the searchd service directly into MySQL instead of going through an application layer.


  • You have to compile SphinxSE into MySQL.
  • Using SphinxSE requires some additional setup besides the basic searchd and indexer configuration.
  • (This one is more my opinion) Searching through the API is more intuitive than using the SphinxSE SQL syntax.
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.