Re: Slow facet sorting - lex vs count

2010-08-26 Thread Eric Grobler
Hi Yonik, Thanks for your help. I will check the memory. It might also be related to patch SOLR-792 tree faceting I installed. I will remove it and try the same query tomorrow again. Regards Eric On Wed, Aug 25, 2010 at 10:25 PM, Yonik Seeley wrote: > On Wed, Aug 25, 2010 at 7:22 AM, Eric Gr

Re: Slow facet sorting - lex vs count

2010-08-25 Thread Yonik Seeley
On Wed, Aug 25, 2010 at 7:22 AM, Eric Grobler wrote: > Hi Solr experts, > > There is a huge difference doing facet sorting on lex vs count > The strange thing is that count sorting is fast when setting a small limit. > I realize I can do sorting in the client, but I am just curious why this is. >

Re: Slow facet sorting - lex vs count

2010-08-25 Thread Yonik Seeley
On Wed, Aug 25, 2010 at 2:50 PM, Yonik Seeley wrote: > On Wed, Aug 25, 2010 at 10:55 AM, Eric Grobler > wrote: >> Thanks for the technical explanation. >> I will in general try to use lex and sort by count in the client if there >> are not too many rows. > > I just developed a patch that may help

Re: Slow facet sorting - lex vs count

2010-08-25 Thread Yonik Seeley
On Wed, Aug 25, 2010 at 10:55 AM, Eric Grobler wrote: > Thanks for the technical explanation. > I will in general try to use lex and sort by count in the client if there > are not too many rows. I just developed a patch that may help this scenario: https://issues.apache.org/jira/browse/SOLR-2089

Re: Slow facet sorting - lex vs count

2010-08-25 Thread Eric Grobler
Hi Yonik, Thanks for the technical explanation. I will in general try to use lex and sort by count in the client if there are not too many rows. Have a nice day. Regards ericz On Wed, Aug 25, 2010 at 4:41 PM, Yonik Seeley wrote: > On Wed, Aug 25, 2010 at 10:07 AM, Eric Grobler > wrote: > > I

Re: Slow facet sorting - lex vs count

2010-08-25 Thread Yonik Seeley
On Wed, Aug 25, 2010 at 10:07 AM, Eric Grobler wrote: > I use Solr 1.41 > There are 14000 cities in the index. > The type is just a simple string: class="solr.StrField" sortMissingLast="true" omitNorms="true"/> > The facet method is fc. > > You are right I do not need 5000 cities, I was just surp

Re: Slow facet sorting - lex vs count

2010-08-25 Thread Eric Grobler
Hi Yonik, Thanks for your response. I use Solr 1.41 There are 14000 cities in the index. The type is just a simple string: The facet method is fc. You are right I do not need 5000 cities, I was just surprised to see this big difference, there are places where I do need to sort count and return

Re: Slow facet sorting - lex vs count

2010-08-25 Thread Yonik Seeley
On Wed, Aug 25, 2010 at 7:22 AM, Eric Grobler wrote: > There is a huge difference doing facet sorting on lex vs count > The strange thing is that count sorting is fast when setting a small limit. > I realize I can do sorting in the client, but I am just curious why this is. There are a lot of opt

Slow facet sorting - lex vs count

2010-08-25 Thread Eric Grobler
Hi Solr experts, There is a huge difference doing facet sorting on lex vs count The strange thing is that count sorting is fast when setting a small limit. I realize I can do sorting in the client, but I am just curious why this is. FAST - 16ms facet.field=city f.city.facet.limit=5000 f.city.face