Re: Query Time problem on Big Index Solr 3.5

2012-08-31 Thread Alexey Serba
1. Use filter queries > Here a example of query, there are any incorrect o anything that can I > change? > http://xxx:8893/solr/candidate/select/?q=+(IdCandidateStatus:2)+(IdCobranded:3)+(IdLocation1:12))+(LastLoginDate:[2011-08-26T00:00:00Z > TO 2012-08-28T00:00:00Z]) What is the logic here? Are

Re: Query Time problem on Big Index Solr 3.5

2012-08-30 Thread pravesh
13 GB index isn't too big, but going forward index sharding is the solutions for large single core indexes. This way you can scale out. This links will give you some info: http://lucidworks.lucidimagination.com/display/solr/Distributed+Search+with+Index+Sharding http://lucidworks.lucidimagination

Re: Query Time problem on Big Index Solr 3.5

2012-08-30 Thread Kiran Jayakumar
Have you tried sharding ? The best practices recommend sharding when your index grows too large and query time is slow. On Tue, Aug 28, 2012 at 2:02 AM, mpcmarcos wrote: > Hello, > > I have a problem, I'm working with Solr 3.5, with a index that has > 8.000.000 > of documents (13Gb), each docum

Re: Query Time problem on Big Index Solr 3.5

2012-08-30 Thread pravesh
How often the documents are added in the index? Try lessen down the optimize frequency. BTW do you optimize only on master (which should be the desired way). Also specifically for dates ranges, try to use the filter queries, this way it would be cached and would thus be faster. This would also a

Re: Query Time problem on Big Index Solr 3.5

2012-08-28 Thread Jack Krupansky
I did notice that you use a lot of the sint/slong/sdouble field types instead of the default int/long/double which are now the much more efficient trie field types, even in Solr 3.5. I have no idea how much of your lackluster performance is due to sint, et al, but I am sure that is a contributi

RE: query time problem

2011-08-10 Thread Charles-Andre Martin
... 21 more Charles-André Martin 800 Square Victoria Montréal (Québec) H4Z 0A3 Tél : (514) 504-2703 -Message d'origine- De : simon [mailto:mtnes...@gmail.com] Envoyé : August-10-11 1:52 PM À : solr-user@lucene.apache.org Objet : Re: query time problem Off the top of my hea

Re: query time problem

2011-08-10 Thread simon
Off the top of my head ... Can you tell if GC is happening more frequently than usual/expected ? Is the index optimized - if not, how many segments ? It's possible that one of the shards is behind a flaky network connection. Is the 10s performance just for the Solr query or wallclock time at t