SphinxClient::setLimits

(PECL sphinx >= 0.1.0)

SphinxClient::setLimits — Set offset and limit of the result set

Beschreibung

public SphinxClient::setLimits ( int $offset , int $limit [, int $max_matches = 0 [, int $cutoff = 0 ]] ) : bool

Sets offset into server-side result set and amount of matches to return to client starting from that offset (limit). Can additionally control maximum server-side result set size for current query (max_matches) and the threshold amount of matches to stop searching at (cutoff).

Parameter-Liste

offset: Result set offset.
limit: Amount of matches to return.
max_matches: Controls how much matches searchd will keep in RAM while searching.
cutoff: Used for advanced performance control. It tells searchd to forcibly stop search query once cutoff matches have been found and processed.

Rückgabewerte

Gibt bei Erfolg TRUE zurück. Im Fehlerfall wird FALSE zurückgegeben.

add a note

User Contributed Notes 4 notes

down

xxxbunker dot com ¶

14 years ago


the max_matches / cutoff parameters are priceless.

if you ever have a situation where you need a 'count' of the number of matches, but only need to display lets say the 'top 10', these 2 parameters are very handy.

we used to get the occasional 'unable to connect' error with sphinx, after implementing these 2 parameters where applicable, these issues disappeared, load dropped, and the servers were much happier.

down

vlk dot abakan at gmail dot com ¶

8 years ago


If you use shpinxQL, you can add "max_matches" option to your query:

<?php
   SELECT ... LIMIT 1000, 10 OPTION max_matches = 1000
?>

And to "searchd" section in sphinx.conf:

<?php

searchd {
    ...
    max_matches = 10000
    ....
}

?>

down

shoanm at users dot sourceforge dot net ¶

15 years ago


I almost pulled out all my hair trying to figure this one out. After applying limits using

$s->setLimit(10,10); 

the search kept returning only false. getLastError() and getLastWarning() contained empty strings. 

The solution, like Nayana stated, is to add a positive non-zero integer $max to setLimit.

down

Nayana Hettiarachch nayana at corp-gems dot com ¶

15 years ago


If you get an error 
per-query max_matches=0 out of bounds (per-server max_matches=1000).

make sure that you also set the $max to a value other than the default 0, 

there is an issue published with a patch if you feel like wanting to patch, 

the first option works well as a workaround. 

http://sphinxsearch.com/bugs/view.php?id=208

add a note