I'm integrating sphinx search with php api in my website and I've got a question.
What is the best practice : - Select only IDs with sphinx, and make an other request in mysql in order to select the other fields (I've some join), with a WHERE IN (ids...) SQL request (but how to keep the same order ?) - Select all datas with sphinx
Thanks.