Author: Doli Stepniewski
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!
My company’s website recently went through the Facebook API v1 to v2 upgrade. Besides having to upgrade the OS on all our web servers so we could upgrade PHP, and having to rewrite our implementation code, the only real undocumented issue was dealing app ID format changes.