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 Doug Kunzman <dk...@usgs.gov> on 2012/11/09 12:08:36 UTC

sort on wild card query not working in solr 3.6

Hi -

We are using SOLR 3.6 and have noticed that when the start parameter is a 
very large number SOLR's performance is rather slow.
After looking at our schema I was hoping to speed up SOLR performance by 
using a sort order since it could be on an index column.
This hasn't worked.  I was wondering if anyone on the list has an idea?

This query takes 1708ms which is very good.
http://bison.usgs.ornl.gov/bisondev_solr/core0/select/?q=provider_id:10&rows=25&start=10&sort:provider_id


This query takes 108129ms which is causing us a lot of problems.
http://bison.usgs.ornl.gov/bisondev_solr/core0/select/?q=*:*&rows=25&start=108524450&sort:id

Is there anything we can do?  I have looked at most of the standard 
documentation on the web but this is my first project using SOLR.

D. Kunzman
12201 Sunrise Valley Drive
Reston, VA 20192

Re: sort on wild card query not working in solr 3.6

Posted by Ahmet Arslan <io...@yahoo.com>.
Hi Doug,

Retrieval Engines are not designed for deep paging (very large start parameter). https://issues.apache.org/jira/browse/SOLR-1726

And your sort syntax is wrong. &sort:id 
It should be &sort=id asc

--- On Fri, 11/9/12, Doug Kunzman <dk...@usgs.gov> wrote:

> From: Doug Kunzman <dk...@usgs.gov>
> Subject: sort on wild card query not working in solr 3.6
> To: solr-user@lucene.apache.org
> Date: Friday, November 9, 2012, 1:08 PM
> Hi -
> 
> We are using SOLR 3.6 and have noticed that when the start
> parameter is a 
> very large number SOLR's performance is rather slow.
> After looking at our schema I was hoping to speed up SOLR
> performance by 
> using a sort order since it could be on an index column.
> This hasn't worked.  I was wondering if anyone on the
> list has an idea?
> 
> This query takes 1708ms which is very good.
> http://bison.usgs.ornl.gov/bisondev_solr/core0/select/?q=provider_id:10&rows=25&start=10&sort:provider_id
> 
> 
> This query takes 108129ms which is causing us a lot of
> problems.
> http://bison.usgs.ornl.gov/bisondev_solr/core0/select/?q=*:*&rows=25&start=108524450&sort:id
> 
> Is there anything we can do?  I have looked at most of
> the standard 
> documentation on the web but this is my first project using
> SOLR.
> 
> D. Kunzman
> 12201 Sunrise Valley Drive
> Reston, VA 20192
> 
>