Using BETWEEN instead of LIMIT and OFFSET proved to be a simple optimization to a troublesome slow MySQL query.
Sphinx documentation doesn’t give examples nor explain how to use SOURCE-TYPE ‘field’ with Multi-Valued Attributes (sql_attr_multi). After experimenting, I discovered that a simple comma delimited list of ids populated in the the referenced field of my record_sphinx_index table does the trick!
Certain DBALs and ORMs don’t provide a functional reset method to clear out schema cruft before rebuilding tables (I’m looking at you, Django). Others like