Query is taking a time in Solr 6.1.0

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Query is taking a time in Solr 6.1.0

vishal patel-2
Some query is taking time in Solr 6.1.0.

2020-03-12 11:05:36.752 INFO  (qtp1239731077-2513155) [c:documents s:shard1 r:core_node1 x:documents] o.a.s.c.S.Request [documents]  webapp=/solr path=/select params={df=summary&distrib=false&fl=id&shards.purpose=4&start=0&fsv=true&sort=doc_ref+asc,id+desc&fq=&shard.url=s3.test.com:8983/solr/documents|s3r1.test.com:8983/solr/documents&rows=250&version=2&q=(doc_ref:((*n205*)+))+AND+(title:((*Distribution\+Board\+Schedule*)+))+AND+project_id:(2104616)+AND+is_active:true+AND+((isLatest:(true)+AND+isFolderActive:true+AND+isXref:false+AND+-document_type_id:(3+7)+AND+((is_public:true+OR+distribution_list:7249777+OR+folderadmin_list:7249777+OR+author_user_id:7249777)+AND+(((allowedUsers:(7249777)+OR+allowedRoles:(6368666)+OR+combinationUsers:(7249777))+AND+-blockedUsers:(7249777))+OR+(defaultAccess:(true)+AND+-blockedUsers:(7249777)+AND+-blockedRoles:(6368666)))))+OR+(isLatestRevPrivate:(true)+AND+allowedUsersForPvtRev:(7249777)+AND+-folderadmin_list:(7249777)))&shards.tolerant=true&NOW=1584011129462&isShard=true&wt=javabin} hits=0 status=0 QTime=7276.

Is there any way to reduce the query execution time(7276 Milli)?
Reply | Threaded
Open this post in threaded view
|

Re: Query is taking a time in Solr 6.1.0

Erik Hatcher-4
Looks like you have two, maybe three, wildcard/prefix clauses in there.  Consider tokenizing differently so you can optimize the queries to not need wildcards - thats my first observation and suggestion.

    Erik

> On Mar 13, 2020, at 05:56, vishal patel <[hidden email]> wrote:
>
> ´╗┐Some query is taking time in Solr 6.1.0.
>
> 2020-03-12 11:05:36.752 INFO  (qtp1239731077-2513155) [c:documents s:shard1 r:core_node1 x:documents] o.a.s.c.S.Request [documents]  webapp=/solr path=/select params={df=summary&distrib=false&fl=id&shards.purpose=4&start=0&fsv=true&sort=doc_ref+asc,id+desc&fq=&shard.url=s3.test.com:8983/solr/documents|s3r1.test.com:8983/solr/documents&rows=250&version=2&q=(doc_ref:((*n205*)+))+AND+(title:((*Distribution\+Board\+Schedule*)+))+AND+project_id:(2104616)+AND+is_active:true+AND+((isLatest:(true)+AND+isFolderActive:true+AND+isXref:false+AND+-document_type_id:(3+7)+AND+((is_public:true+OR+distribution_list:7249777+OR+folderadmin_list:7249777+OR+author_user_id:7249777)+AND+(((allowedUsers:(7249777)+OR+allowedRoles:(6368666)+OR+combinationUsers:(7249777))+AND+-blockedUsers:(7249777))+OR+(defaultAccess:(true)+AND+-blockedUsers:(7249777)+AND+-blockedRoles:(6368666)))))+OR+(isLatestRevPrivate:(true)+AND+allowedUsersForPvtRev:(7249777)+AND+-folderadmin_list:(7249777)))&shards.tolerant=true&NOW=1584011129462&isShard=true&wt=javabin} hits=0 status=0 QTime=7276.
>
> Is there any way to reduce the query execution time(7276 Milli)?
Reply | Threaded
Open this post in threaded view
|

Re: Query is taking a time in Solr 6.1.0

vishal patel-2
How can I use the tokenizing differently?

Sent from Outlook<http://aka.ms/weboutlook>
________________________________
From: Erik Hatcher <[hidden email]>
Sent: Friday, March 13, 2020 6:20 PM
To: [hidden email] <[hidden email]>
Subject: Re: Query is taking a time in Solr 6.1.0

Looks like you have two, maybe three, wildcard/prefix clauses in there.  Consider tokenizing differently so you can optimize the queries to not need wildcards - thats my first observation and suggestion.

    Erik

> On Mar 13, 2020, at 05:56, vishal patel <[hidden email]> wrote:
>
> ´╗┐Some query is taking time in Solr 6.1.0.
>
> 2020-03-12 11:05:36.752 INFO  (qtp1239731077-2513155) [c:documents s:shard1 r:core_node1 x:documents] o.a.s.c.S.Request [documents]  webapp=/solr path=/select params={df=summary&distrib=false&fl=id&shards.purpose=4&start=0&fsv=true&sort=doc_ref+asc,id+desc&fq=&shard.url=s3.test.com:8983/solr/documents|s3r1.test.com:8983/solr/documents&rows=250&version=2&q=(doc_ref:((*n205*)+))+AND+(title:((*Distribution\+Board\+Schedule*)+))+AND+project_id:(2104616)+AND+is_active:true+AND+((isLatest:(true)+AND+isFolderActive:true+AND+isXref:false+AND+-document_type_id:(3+7)+AND+((is_public:true+OR+distribution_list:7249777+OR+folderadmin_list:7249777+OR+author_user_id:7249777)+AND+(((allowedUsers:(7249777)+OR+allowedRoles:(6368666)+OR+combinationUsers:(7249777))+AND+-blockedUsers:(7249777))+OR+(defaultAccess:(true)+AND+-blockedUsers:(7249777)+AND+-blockedRoles:(6368666)))))+OR+(isLatestRevPrivate:(true)+AND+allowedUsersForPvtRev:(7249777)+AND+-folderadmin_list:(7249777)))&shards.tolerant=true&NOW=1584011129462&isShard=true&wt=javabin} hits=0 status=0 QTime=7276.
>
> Is there any way to reduce the query execution time(7276 Milli)?