sphinxql is great for pagination because sorted search results return any attributes essentially replacing a database, will this package work with it?
the queries use regular mysql back-end and look like this:
SELECT * FROM index
WHERE MATCH ('keyword')
AND type IN (1,2,3)
ORDER BY attribute
LIMIT 0, 1000;
also the number of results for the last query is obtained by running another query:
SHOW META;
sphinxql is great for pagination because sorted search results return any attributes essentially replacing a database, will this package work with it?
the queries use regular mysql back-end and look like this:
SELECT * FROM index
WHERE MATCH ('keyword')
AND type IN (1,2,3)
ORDER BY attribute
LIMIT 0, 1000;
also the number of results for the last query is obtained by running another query:
SHOW META;