Better MySQL searches with Sphinx
Use Sphinx for non-full-text searching
From the developerWorks archives
Date archived: April 18, 2019 | First published: November 08, 2011
Even though MySQL is a good general-purpose database, if your application is search-heavy, you may get better performance by using Sphinx instead. Despite Sphinx being a full-text search tool, it can increase the speed of your application even when working with non-full-text queries. This article shows how to configure Sphinx for this task, includes some example queries, measures their execution times, and demonstrates some of the trade-offs involved in the change considering what you need to use Sphinx in a general, systematic way.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some content, steps, or illustrations may have changed.