On 5/13/2019 2:51 AM, vishal patel wrote:
Executing an identical query again will likely satisfy the query from Solr's
caches. Solr won't need to talk to the actual index, and it will be REALLY
fast. Even a massively complex query, if it is cached, will be fast.
All caches are disabled in
Oh, and you can freely set docValues=true _and_ have indexed=true on the same
field, Solr will use the right structure for the operations it needs. HOWEVER:
if you change that definition you _must_ re-index the entire collection.
> On May 13, 2019, at 1:22 AM, Bernd Fehling
> wrote:
>
> Your
That indicates you’re hitting the queryResultCache, which is also supported by
your statement about how fast queries are returned after they’re run once. Look
at admin UI>>select core>>stats/plugins>>cache>>queryResultCache and you’ll
probably see a very hit ratio, approaching 1.
You also have
ery takes a too much time in Solr 6.1.0
Your "sort" parameter has "sort=id+desc,id+desc".
1. It doesn't make sense to have a sort on "id" in descending order twice.
2. Be aware that the id field has the highest cadinality.
3. To speedup sorting have a separate field w
hema file because of our indexing and
searching ratio is high in our live environment.
Sent from Outlook<http://aka.ms/weboutlook>
From: Shawn Heisey
Sent: Friday, May 10, 2019 9:32 PM
To: solr-user@lucene.apache.org
Subject: Re: Solr query takes a too mu
Your "sort" parameter has "sort=id+desc,id+desc".
1. It doesn't make sense to have a sort on "id" in descending order twice.
2. Be aware that the id field has the highest cadinality.
3. To speedup sorting have a separate field with docValues=true for sorting.
E.g.
Regards
Bernd
Am
On 5/10/2019 7:32 AM, vishal patel wrote:
We have 2 shards and 2 replicas in Live environment. we have multiple
collections.
Some times some query takes much time(QTime=52552). There are so many
documents indexing and searching within milliseconds.
There could be any number of causes of
first inclination is your index is cold.
On Fri, May 10, 2019 at 9:32 AM vishal patel
wrote:
> We have 2 shards and 2 replicas in Live environment. we have multiple
> collections.
> Some times some query takes much time(QTime=52552). There are so many
> documents indexing and searching within
We have 2 shards and 2 replicas in Live environment. we have multiple
collections.
Some times some query takes much time(QTime=52552). There are so many
documents indexing and searching within milliseconds.
When we executed the same query again using admin panel, it does not take a
much time
