From solr-user-return-148685-archive-asf-public=cust-asf.ponee.io@lucene.apache.org Wed Jul 3 04:54:30 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 2B4DA18060E for ; Wed, 3 Jul 2019 06:54:30 +0200 (CEST) Received: (qmail 44072 invoked by uid 500); 3 Jul 2019 04:54:10 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 43548 invoked by uid 99); 3 Jul 2019 04:54:09 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Jul 2019 04:54:09 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 1C9FA180DE3 for ; Wed, 3 Jul 2019 04:54:08 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.801 X-Spam-Level: * X-Spam-Status: No, score=1.801 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, WEIRD_QUOTING=0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-he-de.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id exuAXCNSmrhZ for ; Wed, 3 Jul 2019 04:54:06 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=2607:f8b0:4864:20::82e; helo=mail-qt1-x82e.google.com; envelope-from=test.midas@gmail.com; receiver= Received: from mail-qt1-x82e.google.com (mail-qt1-x82e.google.com [IPv6:2607:f8b0:4864:20::82e]) by mx1-he-de.apache.org (ASF Mail Server at mx1-he-de.apache.org) with ESMTPS id 6FDA17E20A for ; Wed, 3 Jul 2019 04:54:05 +0000 (UTC) Received: by mail-qt1-x82e.google.com with SMTP id w17so1111053qto.10 for ; Tue, 02 Jul 2019 21:54:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=t07Fpb+1Kve+4xBTdZkMShf1tmWFQaeEhJGtBKqdxWs=; b=ussp4ZSoxf7pgS5d0fu7u7W+SIXjvoXzqLbK1svPfwkU+lK5jA+JJsx2W27yDqCqMS v/Tv00AM7BVtTNnAbZV/zkkrZK/SPtCtCI8BOQbD/e9Xik9hs8esmRL/TOADi/rka0hx cEv0dW72rpl2Vf1u5r5+tqwKcPaM0g1k+VRSDzj8qJdwx9F3lRyHcZBiROh3CE7B31LR 0c4Rh5I/AkMFtYCG2VZzG3wcSVL+6bRlzmyE8MTVFCbaSxDXAvDt730/nF9P8RaLqYtz Xch7Ms6kZwDcSqdfHKiiWw8a417tyKMMuLuhnXF6SqL4OB2BZwt1pVfQndTAxedoiHUd cnNg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=t07Fpb+1Kve+4xBTdZkMShf1tmWFQaeEhJGtBKqdxWs=; b=RPo22A9IDAQF2rQZAS1+c4YIhedSHz/C2CWI48CFZfuA7suSqvS+/AMoHVT+Id4ROa HFzJOH74hZ48HZ0ewnZkZk8dobhFmbapUmL8C+2W7h7P/ldwXqg4cNCeSaaiAX+q/Z0z TX8PR77BGIOMkh20nyAzFjuxKggG/3wwUDqA6Wam73vUGqmMhU7bOGG2JzDyBD1X2DZp YXUGgM3zCVlZR/6Sq2P71UaTDup1fpB5hO1T1NNzozc2MUqRfJJCagNhmdvI+plEFmMc Ic4QonUDXJJKjJQxq0B0+NwGIN6Qr+C4kYqpnwiup8NSDtI27BCtkp+AMVZ46eHSSHeW ev+g== X-Gm-Message-State: APjAAAUbi5J2uuXdMD66P/QgyySf8uObna+us4j+vtbPggZZffy8pNP4 A/cfRNO5Grb871eQiqDHczahKhXT3mVgC2MlSa/GGb5y X-Google-Smtp-Source: APXvYqzPGu7oxdNAk1PgjVhF8wH7XzWGZAm26XXAk4NXEK4nLgItDdhpmQQDfgi25RSL9uOG4+aUSVx70dp1S3VUWZw= X-Received: by 2002:aed:2667:: with SMTP id z94mr29325537qtc.2.1562129637892; Tue, 02 Jul 2019 21:53:57 -0700 (PDT) MIME-Version: 1.0 From: Midas A Date: Wed, 3 Jul 2019 10:23:46 +0530 Message-ID: Subject: query optimization To: solr-user@lucene.apache.org Content-Type: multipart/alternative; boundary="00000000000028e824058cbfa651" --00000000000028e824058cbfa651 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, How can i optimize following query it is taking time webapp=3D/solr path=3D/search params=3D{ df=3Dttl&ps=3D0&hl=3Dtrue&f.ind.mincount=3D1&hl.usePhraseHighlighter=3Dtrue= &lowercaseOperators=3Dtrue&ps2=3D0&ps3=3D0&qf=3Dcontents^0.05+currdesig^1.5= +predesig^1.5+lng^2+ttl+kw_skl+kw_it&sow=3Dfalse&hl.fl=3Dttl,kw_skl,kw_it,c= ontents&semantictermsttl=3D&f.cat.mincount=3D1&semanticfieldttl=3Dttl^0.1+c= urrdesig^0.1+predesig^0.1&qs=3D0&qt=3D/resumesearch&semantictermsskl=3D"mbb= ss"+OR+"medicine"&version=3D2&omitHeader=3Dtrue&hl.q=3Dmbbs,+"medical+offic= er",+doctor,+physician+("medical+officer")+"medical+officer"+"physician""+"= "general+physician""+""physicians""+""consultant+physician""+""house+physic= ian"+"physician"+"doctor"+"mbbs"+"general+physician"+"physicians"+"consulta= nt+physician"+"house+physician"&typeId=3D(293)&debugQuery=3Dfalse&bq1=3D&ec= hoParams=3Dnone&fl=3Did,upt&f.pref.mincount=3D1&q.op=3DOR&fq=3DNOT+contents= :("liaise+with+medical+officer"+"worked+with+medical+officer"+"working+with= +medical+officer"+"reported+to+medical+officer"+"references+are+medical+off= icer"+"coordinated+with+medical+officer"+"closely+with+medical+officer"+"si= gnature+of+medical+officer"+"seal+of++medical+officer"+"liaise+with+physici= an"+"worked+with+physician"+"working+with+physician"+"reported+to+physician= "+"references+are+physician"+"coordinated+with+physician"+"closely+with+phy= sician"+"signature+of+physician"+"seal+of++physician"+"liaise+with+doctor"+= "worked+with+doctor"+"working+with+doctor"+"reported+to+doctor"+"references= +are+doctor"+"coordinated+with+doctor"+"closely+with+doctor"+"signature+of+= doctor"+"seal+of++doctor")&fq=3DNOT+hemp:("xmwxagency"+"xmwxlimited"+"xmwxp= lacement"+"xmwxplus"+"xmwxprivate"+"xmwxsecurity"+"xmwxz2"+"xmwxand"+"xswxz= 2+plus+placement+and+security+agency+private+limited"+"xswxz2+plus+placemen= t+and+security+agency+private"+"xswxz2+plus+placement+and+security+agency"+= "xswxz2+plus+placement+and+security"+"xswxz2+plus+placement+and"+"xswxz2+pl= us+placement"+"xswxz2+plus"+"xswxz2")&fq=3Dctc:[100.0+TO+107.2]+OR+ctc:[-1.= 0+TO+-1.0]&fq=3D(dlh:(22))&fq=3Dind:(24++42++24++8)&fq=3D(rol:(292+293+294+= 322))&fq=3D(cat:(9))&fq=3Dcat:(1000+OR+907+OR+1+OR+2+OR+3+OR+786+OR+4+OR+5+= OR+6+OR+7+OR+8+OR+9+OR+10+OR+11+OR+12+OR+13+OR+14+OR+785+OR+15+OR+16+OR+17+= OR+18+OR+908+OR+19+OR+20+OR+21+OR+23+OR+24)&fq=3DNOT+is_udis:2&bq=3Dis_resu= me:0^-10000000&bq=3Dupt_date:[*+TO+NOW/DAY-36MONTHS]^2&bq=3Dupt_date:[NOW/D= AY-36MONTHS+TO+NOW/DAY-24MONTHS]^3&bq=3Dupt_date:[NOW/DAY-24MONTHS+TO+NOW/D= AY-12MONTHS]^4&bq=3Dupt_date:[NOW/DAY-12MONTHS+TO+NOW/DAY-9MONTHS]^5&bq=3Du= pt_date:[NOW/DAY-9MONTHS+TO+NOW/DAY-6MONTHS]^10&bq=3Dupt_date:[NOW/DAY-6MON= THS+TO+NOW/DAY-3MONTHS]^15&bq=3Dupt_date:[NOW/DAY-3MONTHS+TO+*]^20&bq=3D_qu= ery_:"{!edismax+qf%3Drol^2+pf%3Did+ps%3D1+pf2%3Did+ps2%3D1+pf3%3Did+ps3%3D1= +v%3D$typeId+q.op%3DOR+bq%3D\$bq1+bf%3D}"&bq=3D_query_:"{!edismax+qf%3Drol^= 2+pf%3Did+ps%3D1+pf2%3Did+ps2%3D1+pf3%3Did+ps3%3D1+v%3D$typeId+q.op%3DOR+bq= %3D\$bq1+bf%3D}"&bq=3D_query_:"{!edismax+qf%3Drol^2+pf%3Did+ps%3D1+pf2%3Did= +ps2%3D1+pf3%3Did+ps3%3D1+v%3D$typeId+q.op%3DOR+bq%3D\$bq1+bf%3D}"&bq=3Ddlh= :(22)^8&bq=3D{!boost+b%3D4}+_query_:{!edismax+qf%3D"currdesig^8+predesig^6+= ttl^3+kw_skl^2+contents"+v%3D"\"doctor\"+\"medical+officer\"+\"physician\""= +q.op%3DAND+bq%3D}&bq=3D_query_:{!edismax+qf%3D"currdesig+predesig+ttl+kw_s= kl+contents^0.01"+v%3D"\"doctor\"+\"medical+officer\"+\"physician\""+q.op%3= DOR+bq%3D}&bq=3DNOT+country:isoin^-1000000000&facet.query=3Dexp:[+10+TO+11+= ]&facet.query=3Dexp:[+11+TO+13+]&facet.query=3Dexp:[+13+TO+15+]&facet.query= =3Dexp:[+15+TO+17+]&facet.query=3Dexp:[+17+TO+20+]&facet.query=3Dexp:[+20+T= O+25+]&facet.query=3Dexp:[+25+TO+109+]&facet.query=3Dctc:[+100+TO+101+]&fac= et.query=3Dctc:[+101+TO+101.5+]&facet.query=3Dctc:[+101.5+TO+102+]&facet.qu= ery=3Dctc:[+102+TO+103+]&facet.query=3Dctc:[+103+TO+104+]&facet.query=3Dctc= :[+104+TO+105+]&facet.query=3Dctc:[+105+TO+107.5+]&facet.query=3Dctc:[+107.= 5+TO+110+]&facet.query=3Dctc:[+110+TO+115+]&facet.query=3Dctc:[+115+TO+1010= 0+]&f.cl.mincount=3D1&queryany3=3D(22)&wt=3Djavabin&queryany2=3D(293)&query= any1=3D(294)&queryany0=3D(322)&facet.field=3Dind&facet.field=3Dcat&facet.fi= eld=3Drol&facet.field=3Dcl&facet.field=3Dpref&debug=3Dfalse&f.rol.mincount= =3D1&start=3D0&rows=3D40&q=3D((mbbs+OR+_query_:"{!edismax+qf%3Ddlh+pf%3Did+= ps%3D1+pf2%3Did+ps2%3D1+pf3%3Did+ps3%3D1+v%3D$queryany3+q.op%3DOR+bq%3D$bq1= +bf%3D}")+OR+((("medical+officer")+OR+"medical+officer"~0)+OR+_query_:"{!ed= ismax+qf%3Drol+pf%3Did+ps%3D1+pf2%3Did+ps2%3D1+pf3%3Did+ps3%3D1+v%3D$querya= ny0+q.op%3DOR+bq%3D$bq1+bf%3D}")+OR+(("doctor"+OR+doctor)+OR+_query_:"{!edi= smax+qf%3Drol+pf%3Did+ps%3D1+pf2%3Did+ps2%3D1+pf3%3Did+ps3%3D1+v%3D$queryan= y2+q.op%3DOR+bq%3D$bq1+bf%3D}")+OR+(("physician"+OR+"physicians"+OR+"genera= l+physician"+OR+"house+physician"+OR+"consultant+physician"+OR+physician)+O= R+_query_:"{!edismax+qf%3Drol+pf%3Did+ps%3D1+pf2%3Did+ps2%3D1+pf3%3Did+ps3%= 3D1+v%3D$queryany1+q.op%3DOR+bq%3D$bq1+bf%3D}")+OR+_query_:"{!edismax+qf%3D= \$semanticfieldskl+pf%3Did+ps%3D1+pf2%3Did+ps2%3D1+pf3%3Did+ps3%3D1+v%3D\$s= emantictermsskl+q.op%3DOR+bq%3D\$bq1+bf%3D}"+OR+_query_:"{!edismax+qf%3D\$s= emanticfieldttl+pf%3Did+ps%3D1+pf2%3Did+ps2%3D1+pf3%3Did+ps3%3D1+v%3D\$sema= ntictermsttl+q.op%3DAND+bq%3D\$bq1+bf%3D}")&facet.limit=3D10&pf=3Did&semant= icfieldskl=3Dkw_skl^0.05+kw_it^0.05+ttl^0.05+currdesig^0.05+predesig^0.05&f= acet.mincount=3D1&pf3=3Did&pf2=3Did&facet=3Dtrue} hits=3D20268 status=3D0 QTime=3D10659 --00000000000028e824058cbfa651--