5 ms·
Last I checked, Sphinx had a huge design flaw in that it indexed directly from an SQL database. In other words, your Sphinx configuration not only needs to have
by lobster_johnson 15y ago
Last I checked, Sphinx had a huge design flaw in that it indexed directly from an SQL database. In other words, your Sphinx configuration not only needs to have read access to the database, it needs to contain the required SQL queries.
This tightly couples Sphinx to your application and your schema, and creates serious issues for your ops team since every app change potentially needs to modify the Sphinx config. It gets particularly hairy when you want to host multiple applications using a single Sphinx daemon.
We started out with Sphinx for our apps but quickly discarded it in favour of ElasticSearch, a much more elegant and orthogonal piece of software.
- shingen 15y agoThat's incorrect. Sphinx can index documents and does not require an SQL database. Such has been the case for a few years now.
- deleted 15y ago[deleted]
- paulsmith 15y agoThat's not true, you can pipe in data from any source: http://sphinxsearch.com/docs/2.0.4/xmlpipe2.html http://sphinxsearch.com/docs/2.0.4/xmlpipe2.html
- barrybhunter 15y agoAlso sphinx as real-time indexes. You send data to sphinx (when you update it), and its indexed right away. The original disk-indexes (updated by a batch process is still available)