You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by vishal patel <vi...@outlook.com> on 2020/03/13 09:56:32 UTC
Query is taking a time in Solr 6.1.0
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)?
Re: Query is taking a time in Solr 6.1.0
Posted by vishal patel <vi...@outlook.com>.
How can I use the tokenizing differently?
Sent from Outlook<http://aka.ms/weboutlook>
________________________________
From: Erik Hatcher <er...@gmail.com>
Sent: Friday, March 13, 2020 6:20 PM
To: solr-user@lucene.apache.org <so...@lucene.apache.org>
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 <vi...@outlook.com> 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)?
Re: Query is taking a time in Solr 6.1.0
Posted by Erik Hatcher <er...@gmail.com>.
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 <vi...@outlook.com> 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)?