I have a very efficient Sphinx query working on a table. However part of the query unfortunatley requires a large 'OR' statement consisting of 100s of options. Sphinx chokes on
field in (1,2,..,800
Field =1 or Field=2 or Field=... or Field=800
Sphinx can do
in(..) queries on ATTRIBUTEs.
Probably not as efficiently as mysql (at least if indexed column)
sphinxQL> SELECT * FROM index WHERE MATCH('...') AND attrib IN (1,2,...)