CODEWITHSUNDEEP
full-text-searchsphinxsphinxql
German Latorre
German Latorre

Reputation: 11158

SphinxQL query does not return all matches

I am usign SphinxQL to query Sphinx RT indexes. Found that queries return 20 matches at most (20 seems to be a default value).

Tried adding options the SELECT query to change that limit to 1000:

SELECT [...] OPTION cutoff = 1000, max_matches = 1000

But got same results.

Is there a way to override the 20 matches result limitation using SphinxQL?

Upvotes: 1

Views: 1933

Answers (1)

barryhunter
barryhunter

Reputation: 21081

Have you tried the LIMIT clause?

From the Docs:

LIMIT clause. Both LIMIT N and LIMIT M,N forms are supported. Unlike in regular SQL (but like in Sphinx API), an implicit LIMIT 0,20 is present by default.

http://sphinxsearch.com/docs/current.html#sphinxql-select

Upvotes: 3

Related Questions