first inclination is your index is cold.
On Fri, May 10, 2019 at 9:32 AM vishal patel <vishalpatel200...@outlook.com>
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.
> When we executed the same query again using admin panel, it does not take
> a much time and it completes within 20 milliseconds.
>
> My Solr Logs :
> 2019-05-10 09:48:56.744 INFO (qtp1239731077-128223) [c:actionscomments
> s:shard1 r:core_node1 x:actionscomments] o.a.s.c.S.Request
> [actionscomments] webapp=/solr path=/select
> params={q=%2Bproject_id:(2102117)%2Brecipient_id:(4642365)+%2Bentity_type:(1)+-action_id:(20+32)+%2Baction_status:(0)+%2Bis_active:(true)+%2B(is_formtype_active:true)+%2B(appType:1)&shards=
> s1.example.com:8983/solr/actionscomments|s1r1.example.com:8983/solr/actionscomments,s2.example.com:8983/solr/actionscomments|s2r1.example.com:8983/solr/actionscomments&indent=off&shards.tolerant=true&fl=id&start=0&sort=id+desc,id+desc&fq=&rows=1
> <http://s1.example.com:8983/solr/actionscomments%7Cs1r1.example.com:8983/solr/actionscomments,s2.example.com:8983/solr/actionscomments%7Cs2r1.example.com:8983/solr/actionscomments&indent=off&shards.tolerant=true&fl=id&start=0&sort=id+desc,id+desc&fq=&rows=1>}
> hits=198 status=0 QTime=52552
> 2019-05-10 09:48:56.744 INFO (qtp1239731077-127998) [c:actionscomments
> s:shard1 r:core_node1 x:actionscomments] o.a.s.c.S.Request
> [actionscomments] webapp=/solr path=/select
> params={q=%2Bproject_id:(2102117)%2Brecipient_id:(4642365)+%2Bentity_type:(1)+-action_id:(20+32)+%2Baction_status:(0)+%2Bis_active:(true)+%2Bdue_date:[2019-05-09T19:30:00Z+TO+2019-05-09T19:30:00Z%2B1DAY]+%2B(is_formtype_active:true)+%2B(appType:1)&shards=
> s1.example.com:8983/solr/actionscomments|s1r1.example.com:8983/solr/actionscomments,s2.example.com:8983/solr/actionscomments|s2r1.example.com:8983/solr/actionscomments&indent=off&shards.tolerant=true&fl=id&start=0&sort=id+desc,id+desc&fq=&rows=1
> <http://s1.example.com:8983/solr/actionscomments%7Cs1r1.example.com:8983/solr/actionscomments,s2.example.com:8983/solr/actionscomments%7Cs2r1.example.com:8983/solr/actionscomments&indent=off&shards.tolerant=true&fl=id&start=0&sort=id+desc,id+desc&fq=&rows=1>}
> hits=0 status=0 QTime=51970
> 2019-05-10 09:48:56.746 INFO (qtp1239731077-128224) [c:actionscomments
> s:shard1 r:core_node1 x:actionscomments] o.a.s.c.S.Request
> [actionscomments] webapp=/solr path=/select
> params={q=%2Bproject_id:(2121600+2115171+2104206)%2Brecipient_id:(2834330)+%2Bentity_type:(2)+-action_id:(20+32)+%2Baction_status:(0)+%2Bis_active:(true)+%2Bdue_date:[2019-05-10T00:00:00Z+TO+2019-05-10T00:00:00Z%2B1DAY]&shards=
> s1.example.com:8983/solr/actionscomments|s1r1.example.com:8983/solr/actionscomments,s2.example.com:8983/solr/actionscomments|s2r1.example.com:8983/solr/actionscomments&indent=off&shards.tolerant=true&fl=id&start=0&sort=id+desc,id+desc&fq=&rows=1
> <http://s1.example.com:8983/solr/actionscomments%7Cs1r1.example.com:8983/solr/actionscomments,s2.example.com:8983/solr/actionscomments%7Cs2r1.example.com:8983/solr/actionscomments&indent=off&shards.tolerant=true&fl=id&start=0&sort=id+desc,id+desc&fq=&rows=1>}
> hits=98 status=0 QTime=51402
>
>
> My schema fields below :
>
> <field name="id" type="string" indexed="true" stored="true"
> required="true" multiValued="false"/>
> <field name="project_id" type="tint" indexed="true" stored="true"/>
> <field name="recipient_id" type="tint" indexed="true" stored="true"/>
> <field name="entity_type" type="tint" indexed="true" stored="true"/>
> <field name="action_id" type="tint" indexed="true" stored="true"/>
> <field name="action_status" type="tint" indexed="true" stored="true"/>
> <field name="is_active" type="boolean" indexed="true" stored="true" />
> <field name="is_formtype_active" type="boolean" indexed="true"
> stored="true" />
> <field name="appType" type="tint" indexed="true" stored="true" />
> <field name="due_date" type="date" indexed="true" stored="true"/>
>
> What could be a problem here? why the query takes too much time at that
> time?
>
> Sent from Outlook<http://aka.ms/weboutlook>
>
