You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Thiago Jackiw <th...@mingle.com> on 2007/05/09 06:56:26 UTC

Returning all rows from a query

Is there a way to retrieve all rows found without having to specify a value for it (?q=sales&rows=HUGE_NUMBER)? For instance, what I'd like to do would be something like "rows=*" or "rows=all" and that would return all the records found, without any limits.

Thanks.

Re: Returning all rows from a query

Posted by Chris Hostetter <ho...@fucit.org>.
: Is there a way to retrieve all rows found without having to specify a
: value for it (?q=sales&rows=HUGE_NUMBER)? For instance, what I'd like to
: do would be something like "rows=*" or "rows=all" and that would return
: all the records found, without any limits.

there's really no good reason to do something like this .. it would be
completley impractical in most cases, you would only want to use it if you
know you are dealing with result sets that are so small they can feasibly
be transmited in a managable amount .. but if that's the case just specify
what you consider a "managable amount" as your HUGE_NUMBER and get the
best of both worlds (all the results when your assumption is right, and a
sanity cap on the result size if it turns out your assumptions are wrong.

that said, i have no problem letting people whot themselves in the foot if
thye want, so if you'd like to submit a patch that makes a negative
value for the "row" param mean "return all" i wouldn't object.

(using a negative value is how facet.limit works so it's more consistent
then "*" or "all")



-Hoss