# Search Performance Issue **URL:** \ **Category:** Elasticsearch\ **Created:** [May 20, 2013, 10:22am UTC](https://discuss.elastic.co/t/search-performance-issue/12036 "2013-05-20T10:22:34Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Maria\_John\_Franklin](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@Maria\_John\_Franklin](https://discuss.elastic.co/u/Maria_John_Franklin)\ **Post date:** [May 20, 2013, 10:22am UTC](https://discuss.elastic.co/t/search-performance-issue/12036/1 "2013-05-20T10:22:34Z")
Hi Friends, ``` Elastic search Performance is very slow when i add multiple OR ``` condition in query string..How to manage that one? # Example ( Discover OR the OR concepts OR and OR experiments OR that OR define OR the OR fields OR of OR genetics OR molecular .....etc) Thanks, Franklin -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![simonw\_2](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/simonw_2/32/1130_2.png) [@simonw\_2](https://discuss.elastic.co/u/simonw_2)\ **Post date:** [May 20, 2013, 11:21am UTC](https://discuss.elastic.co/t/search-performance-issue/12036/2 "2013-05-20T11:21:34Z")
hey, so the most likely problem here is the terms with high-frequency like "the", "and"... you can either drop those entirely by using stopword filters or you can be more dynamic and build you query with a match query and use the cutoff\_freq (a cut off frequency where terms will be promoted to be entirely optional unless one of the others match) > **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)** > > Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today. { "match" : { "message" : { "query" : "Discover the concepts and experiments that define the fields of genetics molecular...", "cutoff\_frequency" : 0.001 } } } the query above is equivalent to what you did below except of the fact that high freq terms are only considered if one of the other terms match. simon On Monday, May 20, 2013 12:22:34 PM UTC+2, Maria John Franklin wrote: > Hi Friends, > > ``` > Elastic search Performance is very slow when i add multiple OR > > ``` > > condition in query string..How to manage that one? > > # Example > > ( Discover OR the OR concepts OR and OR experiments OR that OR > define OR the OR fields OR of OR genetics OR molecular .....etc) > > Thanks, > Franklin -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Maria\_John\_Franklin](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@Maria\_John\_Franklin](https://discuss.elastic.co/u/Maria_John_Franklin)\ **Post date:** [May 28, 2013, 10:26am UTC](https://discuss.elastic.co/t/search-performance-issue/12036/3 "2013-05-28T10:26:22Z")
On Monday, May 20, 2013 6:22:34 PM UTC+8, Maria John Franklin wrote: > Hi Friends, > > ``` > Elastic search Performance is very slow when i add multiple OR > > ``` > > condition in query string..How to manage that one? > > # Example > > ( Discover OR the OR concepts OR and OR experiments OR that OR > define OR the OR fields OR of OR genetics OR molecular .....etc) > Thanks, > Franklin Hi simonw, Thanks for ur reply..How to add cutoff\_frequency in My query? My sample Query is below { "from": {{1}}, "size": {{10}}, "fields" :["test","test1","test2","test3","test4"], "query": { "bool": { "must": [ {{@testquery}} /////condition sample ( Discover OR the OR concepts OR and OR experiments OR that OR define OR the OR fields OR of OR genetics OR molecula ..etc) ] } }, "sort": [{{@SORTQUERY}}], "facets": {{@FACETQUERY}} } Thanks, Franklin -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Maria\_John\_Franklin](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@Maria\_John\_Franklin](https://discuss.elastic.co/u/Maria_John_Franklin)\ **Post date:** [May 28, 2013, 10:48am UTC](https://discuss.elastic.co/t/search-performance-issue/12036/4 "2013-05-28T10:48:32Z")
On Monday, May 20, 2013 6:22:34 PM UTC+8, Maria John Franklin wrote: > Hi Friends, > > ``` > Elastic search Performance is very slow when i add multiple OR > > ``` > > condition in query string..How to manage that one? > > # Example > > ( Discover OR the OR concepts OR and OR experiments OR that OR > define OR the OR fields OR of OR genetics OR molecular .....etc) > Thanks, > Franklin Hi simonw, Thanks for ur reply..How to add cutoff\_frequency in My query? My sample Query is below { "from": {{1}}, "size": {{10}}, "fields" :["test","test1","test2","test3","test4"], "query": { "bool": { "must": [ {{@testquery}} /////condition sample 1 ( Discover OR the OR concepts OR and OR experiments OR that OR define OR the OR fields OR of OR genetics OR molecula ..etc) ``` /////condition sample 2 ((Discover AND concepts ``` ) OR genetics OR experiments ) ] } }, "sort": [{{@SORTQUERY}}], "facets": {{@FACETQUERY}} } Thanks, Franklin -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Maria\_John\_Franklin](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@Maria\_John\_Franklin](https://discuss.elastic.co/u/Maria_John_Franklin)\ **Post date:** [May 28, 2013, 11:22am UTC](https://discuss.elastic.co/t/search-performance-issue/12036/5 "2013-05-28T11:22:29Z")
On Monday, May 20, 2013 6:22:34 PM UTC+8, Maria John Franklin wrote: > Hi Friends, > > ``` > Elastic search Performance is very slow when i add multiple OR > > ``` > > condition in query string..How to manage that one? > > # Example > > ( Discover OR the OR concepts OR and OR experiments OR that OR > define OR the OR fields OR of OR genetics OR molecular .....etc) > > Thanks, > Franklin Hi Simonw, This is my exact query..How to increase performance in this query? { "from": 0, "size": 10, "fields" :["test","test1","test2","test3","test4"], "query": { "bool": { "must": [ { "query\_string": { "query": "(((ascorbic) AND (acid,) AND (folic) AND (acid,) AND (niacin,) AND (thiamine,) AND (riboflavin,) AND (pyridoxine,) AND (cyanocobalamin,) AND (pantothenic) AND (acid,) AND (biotin)) OR ((nephrocaps)) OR ((multivitamin)) OR ((folbee)) OR ((vitamin) AND b AND (complex) AND (injectable)) OR ((therems)) OR ((rena‐vite) AND (rx)) OR ((unicap)) OR ((1000) AND (bc)) OR ((lipotriad)) OR ((vitamin) AND b AND (complex)) OR ((vitamin) AND (b‐100) AND (t/r)) OR ((bee‐comp) AND (with) AND (c)) OR ((folmor)) OR ((nephro‐vite)) OR ((balanced) AND (b‐150)) OR ((vita‐ret) AND (500)) OR ((neuroforte‐six)) OR ((poly‐vi‐sol) AND (drops)) OR ((tri‐vi‐sol)) OR ((super) AND (b‐100) AND (td)) OR ((balanced) AND (b‐100)) OR ((m.v.i.‐12)) OR ((foltx)) OR ((nephrolan) AND (rx)) OR ((cod) AND (liver) AND (oil)) OR ((baby) AND (vitamin) AND (drop)) OR ((equaline) AND (one) AND (daily) AND (essential)) OR ((lipogen)) OR ((triphro)) OR ((formula) AND (b)) OR ((poly‐vi‐sol)) OR ((vitamin) AND b AND (complex) AND (with) AND (c)) OR ((liponol)) OR ((hexavitamin)) OR ((cholinoid)) OR ((one‐a‐day) AND (50+)) OR ((high) AND b AND (complex)) OR ((cerefolin)) OR ((vitamin) AND (c,) AND (e,) AND (rose) AND (hips)) OR ((cholidase)) OR ((poly) AND (vit) AND (drops)) OR ((sunkist) AND (child) AND (chewable)) OR ((nephronex)) OR ((alz‐nac)) OR ((dialyvite) AND (800)) OR ((beminal‐500)) OR ((cardiotek‐rx)) OR ((poly‐vita) AND (drops)) OR ((reno) AND (caps)) OR ((stresstabs)) OR ((primaplex)) OR ((becomject‐100)) OR ((balanced) AND (b‐100) AND (high) AND (potency) AND (caplets)) OR ((super) AND (aytinal) AND (for) AND (active) AND (adults)) OR ((vitamin) AND b AND (complex) AND (with) AND (vitamin) AND (c)) OR ((vitamin) AND (b‐plex)) OR ((vi‐daylin) AND (adc)) OR ((neurodep)) OR ((unicap) AND (capsule)) OR ((fruity) AND (chew)) OR ((folcaps)) OR ((folbee) AND (ar)) OR ((biotin) AND (forte)) OR ((nephplex) AND (rx)) OR ((protegra)) OR ((poly‐vit) AND (chew)) OR ((vitamin) AND (b‐100)) OR ((vitamins) AND (for) AND (hair)) OR ((vicam)) OR ((renatabs)) OR ((fabb)) OR ((rena‐vite)) OR ((infuvite)) OR ((cota‐b‐plex)) OR ((poly) AND (vit) AND (with) AND (infant) AND (drop)) OR ((vitacirc‐b)) OR ((nephrocaps) AND (qt)) OR ((l‐methyl‐b6‐b12)) OR ((bounty) AND (bear) AND (vitamins)) OR ((folic) AND (acid/vitamin) AND b AND (complex/vitamin) AND (c)) OR ((mega) AND (b)) OR ((vitamin) AND (liquid)) OR ((tri‐vit) AND (drops)) OR ((vitamin) AND (a) AND d AND (softgels)) OR ((apatate)) OR ((high) AND (potency) AND (b+c)) OR ((t‐vites)) OR ((b‐plex)) OR ((combgen)) OR ((vita‐respa)) OR ((folamin)) OR ((foltrate)) OR ((stress) AND b AND (with) AND (c)) OR ((l‐methylfolate) AND (ca,) AND (me‐cbl) AND (nac)) OR ((surbex)) OR ((triveen‐cf)) OR ((renaphro)) OR ((one‐a‐day) AND (essentials)) OR ((sunkist) AND (child) AND (chewable) AND (with) AND (c)) OR ((one) AND (daily)) OR ((vesselvite)) OR ((b‐ject) AND (100)) OR ((enfolast‐n)) OR ((folbee) AND (plus)) OR ((folastin)) OR ((therobec)) OR ((theragenerix)) OR ((megaton)) OR ((tri‐vit)) OR ((enfolast)) OR ((dialyvite) AND (rx)) OR ((renal) AND (caps)) OR ((b‐plex) AND (plus)) OR ((tri‐vita) AND (drops)) OR ((vi‐stress)) OR ((d‐400) AND (international) AND (units)) OR ((tab‐a‐vite)) OR ((b) AND (complex)) OR ((vol‐care) AND (rx)) OR ((folast)) OR ((protegra) AND (cardio)) OR ((folic) AND (acid/cyanocobalamin/pyridoxine) AND (hydrochloride)) OR ((vita) AND (drop)) OR ((vitamin) AND (a,) AND (d)) OR ((rovin‐cf)) OR ((apetigen)) OR ((folbalin)) OR ((key‐plex)) OR ((b‐scorbic)) OR ((surbex‐t)) OR ((cardiotek)) OR ((multiple) AND (vitamins) AND (essentials)) OR ((vitaplex)) OR ((morplex)) OR ((balanced) AND (b‐50)) OR ((folplex)) OR ((glutofac)) OR ((cardiotek) AND (rx)) OR ((oncovite)) OR ((surbex) AND (with) AND (c)) OR ((vi‐daylin) AND (drops)) OR ((scotts) AND (emulsion)) OR ((vitamin) AND b AND (complex) AND (with) AND (vitamin) AND (c) AND (b12)) OR ((cod) AND (liver) AND (oil) AND (mint)) OR ((vitamin) AND b AND (complex) AND (with) AND (b12)) OR ((lipoflavonoid)) OR ((neurpath‐b)) OR ((b‐complex) AND (50)) OR ((foltabs) AND (800)) OR ((therapeutic) AND (vitamins)) OR ((folbalin) AND (plus)) OR ((allbee‐c) AND (800)) OR ((allbee‐c)) OR ((zycose)) OR ((diatx)) OR ((theragran)) OR ((sesame) AND (st.) AND (vitamins) AND (with) AND (extra) AND (c)) OR ((folgard) AND ((obsolete))) OR ((nephrocaps)) OR ((multivitamin)) OR ((flintstones) AND (multivitamins)) OR ((folgard) AND (rx)) OR ((vitamin) AND b AND (complex) AND (100)) OR ((cefol)) OR ((super) AND b AND (complex) AND (with) AND (c)) OR ((flintstones) AND (with) AND c AND (multivitamins)) OR ((tl) AND (gard)) OR ((daily) AND (multiple) AND (vitamins)) OR ((superplex‐t)) OR ((foleve)) OR ((thex) AND (forte)) OR ((m.v.i.) AND (pediatric)) OR ((vigomar) AND (forte)) OR ((super) AND (plenamins)) OR ((ivites) AND (rx)) OR ((multi) AND (vits) AND (with) AND (beta) AND (carotene)) OR ((allantex)) OR ((foleve) AND (plus)) OR ((b) AND (complex) AND (50)) OR ((nephro‐vite) AND (rx)) OR ((vitamin) AND b AND (complex) AND (t/r)) OR ((dayalets)) OR ((b‐complex)) OR ((cerefolinnac)) OR ((niafol)) OR ((folbic)) OR ((super) AND (aytinal) AND (50) AND (plus)) OR ((farbee) AND (with) AND (c)) OR ((garfield) AND (vitamins) AND (with) AND (c)) OR ((b) AND (100) AND (complex)) OR ((sigtab)) OR ((vimar)) OR ((folnate) AND (plus)) OR ((daily‐vite) AND (men's) AND (formula)) OR ((cernevit)) OR ((l‐methylfolate) AND (ca,) AND (p‐5‐p,) AND (me‐cbl)) OR ((vi‐daylin) AND (chewable)) OR ((mtx) AND (support)) OR ((may‐vita)) OR ((stress) AND (formula) AND (600)) OR ((bee) AND (with) AND (c)) OR ((child) AND (circus)) OR ((berocca)) OR ((stress) AND (formula) AND (caplets)) OR ((thera‐plus)) OR ((daily) AND (vite)) OR ((multi‐delyn)) OR ((m.v.c.) AND (sdv)) OR ((kenwood) AND (therapeutic)) OR ((b‐complex) AND (sr)) OR ((folplex) AND (2.2)) OR ((vitamin) AND (daily) AND (liquid)) OR ((bugs) AND (bunny) AND (with) AND (extra) AND (c)) OR ((folnate)) OR ((b‐50) AND (complex)) OR ((therapeutic) AND (b+c)) OR ((children's) AND (chewable) AND (multivitamins)) OR ((theravite)) OR ((vitamin) AND (b‐50)) OR ((high) AND (potency) AND b AND (complex) AND (with) AND (b12) AND (c)) OR ((nufol)) OR ((m.v.i.) AND (adult)) OR ((one‐a‐day) AND (men's) AND (health) AND (formula)) OR ((b‐stress)) OR ((chewable) AND (vitamins)) OR ((uni‐daily)) OR ((folgard) AND (rx) AND (2.2)) OR ((vi‐daylin)) OR ((super) AND b AND (complex)) OR ((apetex)) OR ((unicap) AND (jr.)) OR ((chewable‐vite)) OR ((multi‐day)) OR ((b‐complex) AND (with) AND (b‐12)) OR ((optilets‐500)) OR ((vitabee) AND (with) AND (c)) OR ((nutrifac) AND (zx)) OR ((thera)) OR ((dexfol)) OR ((garfield) AND (vitamins)) OR ((animal) AND (shape) AND (vitamins)) OR ((zymacap)) OR ((one) AND (tab) AND (daily)) OR ((menopause) AND (relief) AND (with) AND (lifenol)) OR ((stress) AND (formula)) OR ((cernevit‐12)) OR ((vitamin) AND (b+c)) OR ((essential) AND (balance)) OR ((prostate) AND (2.4)) OR ((metanx)) OR ((super) AND (b‐50)) OR ((infuvite) AND (pediatric)) OR ((b‐50) AND (balanced)) OR ((land) AND (before) AND (time) AND (children's) AND (with) AND (vitamin) AND (c)) OR ((balanced) AND (b‐100) AND (time) AND (released) AND (high) AND (potency) AND (caplets)) OR ((pyridoxine) AND (cyanocobalamin) AND (folic) AND (acid)) OR ((folbic)))" } } ], "cutoff\_frequency" : 0.001 } }, "sort": [{{@SORTQUERY}}], "facets": {{@FACETQUERY}} } } } Thanks, Franklin -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Nicolas\_Labrot](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nicolas_labrot/32/2177_2.png) [@Nicolas\_Labrot](https://discuss.elastic.co/u/Nicolas_Labrot)\ **Post date:** [May 28, 2013, 12:23pm UTC](https://discuss.elastic.co/t/search-performance-issue/12036/6 "2013-05-28T12:23:01Z")
You shoud try to use filter instead of query. I don't think a score is relevant with this type of query. On Tue, May 28, 2013 at 1:22 PM, Maria John Franklin \< [mariajohnfranklin@mycura.com](mailto:mariajohnfranklin@mycura.com)\> wrote: > On Monday, May 20, 2013 6:22:34 PM UTC+8, Maria John Franklin wrote: > > > Hi Friends, > > > > ``` > > Elastic search Performance is very slow when i add multiple OR > > > > ``` > > > > condition in query string..How to manage that one? > > > > # Example > > > > ( Discover OR the OR concepts OR and OR \*\*experiments OR that OR > > define OR the OR \*\*fields OR of OR genetics OR molecular .....etc) > > > > Thanks, > > Franklin > > Hi Simonw, > This is my exact query..How to increase performance in this query? > > { > "from": 0, > "size": 10, > "fields" :["test","test1","test2","\*\*test3","test4"], > "query": { > "bool": { > "must": [ > { > "query\_string": { > "query": "(((ascorbic) AND (acid,) AND (folic) AND (acid,) AND > (niacin,) AND (thiamine,) AND (riboflavin,) AND (pyridoxine,) AND > (cyanocobalamin,) AND (pantothenic) AND (acid,) AND (biotin)) OR > ((nephrocaps)) OR ((multivitamin)) OR ((folbee)) OR ((vitamin) AND b > AND (complex) AND (injectable)) OR ((therems)) OR ((rena‐vite) > AND (rx)) OR ((unicap)) OR ((1000) AND (bc)) OR ((lipotriad)) OR > ((vitamin) AND b AND (complex)) OR ((vitamin) AND (b‐100) AND > (t/r)) OR ((bee‐comp) AND (with) AND (c)) OR ((folmor)) OR > ((nephro‐vite)) OR ((balanced) AND (b‐150)) OR > ((vita‐ret) AND (500)) OR ((neuroforte‐six)) OR > ((poly‐vi‐sol) AND (drops)) OR ((tri‐vi‐sol)) OR > ((super) AND (b‐100) AND (td)) OR ((balanced) AND (b‐100)) > OR ((m.v.i.‐12)) OR ((foltx)) OR ((nephrolan) AND (rx)) OR > ((cod) AND (liver) AND (oil)) OR ((baby) AND (vitamin) AND (drop)) OR > ((equaline) AND (one) AND (daily) AND (essential)) OR ((lipogen)) OR > ((triphro)) OR ((formula) AND (b)) OR ((poly‐vi‐sol)) OR > ((vitamin) AND b AND (complex) AND (with) AND (c)) OR ((liponol)) OR > ((hexavitamin)) OR ((cholinoid)) OR ((one‐a‐day) AND (50+)) > OR ((high) AND b AND (complex)) OR ((cerefolin)) OR ((vitamin) AND > (c,) AND (e,) AND (rose) AND (hips)) OR ((cholidase)) OR ((poly) AND > (vit) AND (drops)) OR ((sunkist) AND (child) AND (chewable)) OR > ((nephronex)) OR ((alz‐nac)) OR ((dialyvite) AND (800)) OR > ((beminal‐500)) OR ((cardiotek‐rx)) OR ((poly‐vita) > AND (drops)) OR ((reno) AND (caps)) OR ((stresstabs)) OR ((primaplex)) > OR ((becomject‐100)) OR ((balanced) AND (b‐100) AND (high) > AND (potency) AND (caplets)) OR ((super) AND (aytinal) AND (for) AND > (active) AND (adults)) OR ((vitamin) AND b AND (complex) AND (with) > AND (vitamin) AND (c)) OR ((vitamin) AND (b‐plex)) OR > ((vi‐daylin) AND (adc)) OR ((neurodep)) OR ((unicap) AND > (capsule)) OR ((fruity) AND (chew)) OR ((folcaps)) OR ((folbee) AND > (ar)) OR ((biotin) AND (forte)) OR ((nephplex) AND (rx)) OR > ((protegra)) OR ((poly‐vit) AND (chew)) OR ((vitamin) AND > (b‐100)) OR ((vitamins) AND (for) AND (hair)) OR ((vicam)) OR > ((renatabs)) OR ((fabb)) OR ((rena‐vite)) OR ((infuvite)) OR > ((cota‐b‐plex)) OR ((poly) AND (vit) AND (with) AND > (infant) AND (drop)) OR ((vitacirc‐b)) OR ((nephrocaps) AND > (qt)) OR ((l‐methyl‐b6‐b12)) OR ((bounty) AND (bear) > AND (vitamins)) OR ((folic) AND (acid/vitamin) AND b AND > (complex/vitamin) AND (c)) OR ((mega) AND (b)) OR ((vitamin) AND > (liquid)) OR ((tri‐vit) AND (drops)) OR ((vitamin) AND (a) AND > d AND (softgels)) OR ((apatate)) OR ((high) AND (potency) AND (b+c)) > OR ((t‐vites)) OR ((b‐plex)) OR ((combgen)) OR > ((vita‐respa)) OR ((folamin)) OR ((foltrate)) OR ((stress) AND b > AND (with) AND (c)) OR ((l‐methylfolate) AND (ca,) AND > (me‐cbl) AND (nac)) OR ((surbex)) OR ((triveen‐cf)) OR > ((renaphro)) OR ((one‐a‐day) AND (essentials)) OR > ((sunkist) AND (child) AND (chewable) AND (with) AND (c)) OR ((one) > AND (daily)) OR ((vesselvite)) OR ((b‐ject) AND (100)) OR > ((enfolast‐n)) OR ((folbee) AND (plus)) OR ((folastin)) OR > ((therobec)) OR ((theragenerix)) OR ((megaton)) OR ((tri‐vit)) OR > ((enfolast)) OR ((dialyvite) AND (rx)) OR ((renal) AND (caps)) OR > ((b‐plex) AND (plus)) OR ((tri‐vita) AND (drops)) OR > ((vi‐stress)) OR ((d‐400) AND (international) AND (units)) > OR ((tab‐a‐vite)) OR ((b) AND (complex)) OR > ((vol‐care) AND (rx)) OR ((folast)) OR ((protegra) AND (cardio)) > OR ((folic) AND (acid/cyanocobalamin/pyridoxine) AND (hydrochloride)) OR > ((vita) AND (drop)) OR ((vitamin) AND (a,) AND (d)) OR > ((rovin‐cf)) OR ((apetigen)) OR ((folbalin)) OR > ((key‐plex)) OR ((b‐scorbic)) OR ((surbex‐t)) OR > ((cardiotek)) OR ((multiple) AND (vitamins) AND (essentials)) OR > ((vitaplex)) OR ((morplex)) OR ((balanced) AND (b‐50)) OR > ((folplex)) OR ((glutofac)) OR ((cardiotek) AND (rx)) OR ((oncovite)) > OR ((surbex) AND (with) AND (c)) OR ((vi‐daylin) AND (drops)) OR > ((scotts) AND (emulsion)) OR ((vitamin) AND b AND (complex) AND > (with) AND (vitamin) AND (c) AND (b12)) OR ((cod) AND (liver) AND > (oil) AND (mint)) OR ((vitamin) AND b AND (complex) AND (with) AND > (b12)) OR ((lipoflavonoid)) OR ((neurpath‐b)) OR > ((b‐complex) AND (50)) OR ((foltabs) AND (800)) OR > ((therapeutic) AND (vitamins)) OR ((folbalin) AND (plus)) OR > ((allbee‐c) AND (800)) OR ((allbee‐c)) OR ((zycose)) OR > ((diatx)) OR ((theragran)) OR ((sesame) AND (st.) AND (vitamins) AND > (with) AND (extra) AND (c)) OR ((folgard) AND ((obsolete))) OR > ((nephrocaps)) OR ((multivitamin)) OR ((flintstones) AND > (multivitamins)) OR ((folgard) AND (rx)) OR ((vitamin) AND b AND > (complex) AND (100)) OR ((cefol)) OR ((super) AND b AND (complex) AND > (with) AND (c)) OR ((flintstones) AND (with) AND c AND > (multivitamins)) OR ((tl) AND (gard)) OR ((daily) AND (multiple) AND > (vitamins)) OR ((superplex‐t)) OR ((foleve)) OR ((thex) AND > (forte)) OR ((m.v.i.) AND (pediatric)) OR ((vigomar) AND (forte)) OR > ((super) AND (plenamins)) OR ((ivites) AND (rx)) OR ((multi) AND > (vits) AND (with) AND (beta) AND (carotene)) OR ((allantex)) OR > ((foleve) AND (plus)) OR ((b) AND (complex) AND (50)) OR > ((nephro‐vite) AND (rx)) OR ((vitamin) AND b AND (complex) AND > (t/r)) OR ((dayalets)) OR ((b‐complex)) OR ((cerefolinnac)) OR > ((niafol)) OR ((folbic)) OR ((super) AND (aytinal) AND (50) AND > (plus)) OR ((farbee) AND (with) AND (c)) OR ((garfield) AND > (vitamins) AND (with) AND (c)) OR ((b) AND (100) AND (complex)) OR > ((sigtab)) OR ((vimar)) OR ((folnate) AND (plus)) OR > ((daily‐vite) AND (men's) AND (formula)) OR ((cernevit)) OR > ((l‐methylfolate) AND (ca,) AND (p‐5‐p,) AND > (me‐cbl)) OR ((vi‐daylin) AND (chewable)) OR ((mtx) AND > (support)) OR ((may‐vita)) OR ((stress) AND (formula) AND (600)) > OR ((bee) AND (with) AND (c)) OR ((child) AND (circus)) OR > ((berocca)) OR ((stress) AND (formula) AND (caplets)) OR > ((thera‐plus)) OR ((daily) AND (vite)) OR ((multi‐delyn)) > OR ((m.v.c.) AND (sdv)) OR ((kenwood) AND (therapeutic)) OR > ((b‐complex) AND (sr)) OR ((folplex) AND (2.2)) OR ((vitamin) > AND (daily) AND (liquid)) OR ((bugs) AND (bunny) AND (with) AND > (extra) AND (c)) OR ((folnate)) OR ((b‐50) AND (complex)) OR > ((therapeutic) AND (b+c)) OR ((children's) AND (chewable) AND > (multivitamins)) OR ((theravite)) OR ((vitamin) AND (b‐50)) OR > ((high) AND (potency) AND b AND (complex) AND (with) AND (b12) AND > (c)) OR ((nufol)) OR ((m.v.i.) AND (adult)) OR > ((one‐a‐day) AND (men's) AND (health) AND (formula)) OR > ((b‐stress)) OR ((chewable) AND (vitamins)) OR > ((uni‐daily)) OR ((folgard) AND (rx) AND (2.2)) OR > ((vi‐daylin)) OR ((super) AND b AND (complex)) OR ((apetex)) OR > ((unicap) AND (jr.)) OR ((chewable‐vite)) OR ((multi‐day)) > OR ((b‐complex) AND (with) AND (b‐12)) OR > ((optilets‐500)) OR ((vitabee) AND (with) AND (c)) OR > ((nutrifac) AND (zx)) OR ((thera)) OR ((dexfol)) OR ((garfield) AND > (vitamins)) OR ((animal) AND (shape) AND (vitamins)) OR ((zymacap)) OR > ((one) AND (tab) AND (daily)) OR ((menopause) AND (relief) AND (with) > AND (lifenol)) OR ((stress) AND (formula)) OR ((cernevit‐12)) OR > ((vitamin) AND (b+c)) OR ((essential) AND (balance)) OR ((prostate) > AND (2.4)) OR ((metanx)) OR ((super) AND (b‐50)) OR ((infuvite) > AND (pediatric)) OR ((b‐50) AND (balanced)) OR ((land) AND > (before) AND (time) AND (children's) AND (with) AND (vitamin) AND > (c)) OR ((balanced) AND (b‐100) AND (time) AND (released) AND > (high) AND (potency) AND (caplets)) OR ((pyridoxine) AND > (cyanocobalamin) AND (folic) AND (acid)) OR ((folbic)))" > } > } > ], > "cutoff\_frequency" : 0.001 > } > }, > "sort": [{{@SORTQUERY}}], > "facets": {{@FACETQUERY}} > } > } > } > > Thanks, > Franklin > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![simonw\_2](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/simonw_2/32/1130_2.png) [@simonw\_2](https://discuss.elastic.co/u/simonw_2)\ **Post date:** [May 28, 2013, 1:04pm UTC](https://discuss.elastic.co/t/search-performance-issue/12036/7 "2013-05-28T13:04:46Z")
filters won't help here. Can you provide some info how slow the query is? I mean what is the usecase for this query, are you doing patent searches? I really can't see how can make this fast really. The only think I can think of is to change the structure entirely but without usecase hard to tell. simon On Tuesday, May 28, 2013 2:23:01 PM UTC+2, Nicolas Labrot wrote: > You shoud try to use filter instead of query. I don't think a score is > relevant with this type of query. > > On Tue, May 28, 2013 at 1:22 PM, Maria John Franklin \< > [mariajoh...@mycura.com](mailto:mariajoh...@mycura.com) \\> wrote: > > > On Monday, May 20, 2013 6:22:34 PM UTC+8, Maria John Franklin wrote: > > > > > Hi Friends, > > > > > > ``` > > > Elastic search Performance is very slow when i add multiple OR > > > > > > ``` > > > > > > condition in query string..How to manage that one? > > > > > > # Example > > > > > > ( Discover OR the OR concepts OR and OR \*\*experiments OR that OR > > > define OR the OR \*\*fields OR of OR genetics OR molecular .....etc) > > > > > > Thanks, > > > Franklin > > > > Hi Simonw, > > This is my exact query..How to increase performance in this query? > > > > { > > "from": 0, > > "size": 10, > > "fields" :["test","test1","test2","\*\*test3","test4"], > > "query": { > > "bool": { > > "must": [ > > { > > "query\_string": { > > "query": "(((ascorbic) AND (acid,) AND (folic) AND (acid,) AND > > (niacin,) AND (thiamine,) AND (riboflavin,) AND (pyridoxine,) AND > > (cyanocobalamin,) AND (pantothenic) AND (acid,) AND (biotin)) OR > > ((nephrocaps)) OR ((multivitamin)) OR ((folbee)) OR ((vitamin) AND b > > AND (complex) AND (injectable)) OR ((therems)) OR ((rena‐vite) > > AND (rx)) OR ((unicap)) OR ((1000) AND (bc)) OR ((lipotriad)) OR > > ((vitamin) AND b AND (complex)) OR ((vitamin) AND (b‐100) AND > > (t/r)) OR ((bee‐comp) AND (with) AND (c)) OR ((folmor)) OR > > ((nephro‐vite)) OR ((balanced) AND (b‐150)) OR > > ((vita‐ret) AND (500)) OR ((neuroforte‐six)) OR > > ((poly‐vi‐sol) AND (drops)) OR ((tri‐vi‐sol)) OR > > ((super) AND (b‐100) AND (td)) OR ((balanced) AND (b‐100)) > > OR ((m.v.i.‐12)) OR ((foltx)) OR ((nephrolan) AND (rx)) OR > > ((cod) AND (liver) AND (oil)) OR ((baby) AND (vitamin) AND (drop)) OR > > ((equaline) AND (one) AND (daily) AND (essential)) OR ((lipogen)) OR > > ((triphro)) OR ((formula) AND (b)) OR ((poly‐vi‐sol)) OR > > ((vitamin) AND b AND (complex) AND (with) AND (c)) OR ((liponol)) OR > > ((hexavitamin)) OR ((cholinoid)) OR ((one‐a‐day) AND (50+)) > > OR ((high) AND b AND (complex)) OR ((cerefolin)) OR ((vitamin) AND > > (c,) AND (e,) AND (rose) AND (hips)) OR ((cholidase)) OR ((poly) AND > > (vit) AND (drops)) OR ((sunkist) AND (child) AND (chewable)) OR > > ((nephronex)) OR ((alz‐nac)) OR ((dialyvite) AND (800)) OR > > ((beminal‐500)) OR ((cardiotek‐rx)) OR ((poly‐vita) > > AND (drops)) OR ((reno) AND (caps)) OR ((stresstabs)) OR ((primaplex)) > > OR ((becomject‐100)) OR ((balanced) AND (b‐100) AND (high) > > AND (potency) AND (caplets)) OR ((super) AND (aytinal) AND (for) AND > > (active) AND (adults)) OR ((vitamin) AND b AND (complex) AND (with) > > AND (vitamin) AND (c)) OR ((vitamin) AND (b‐plex)) OR > > ((vi‐daylin) AND (adc)) OR ((neurodep)) OR ((unicap) AND > > (capsule)) OR ((fruity) AND (chew)) OR ((folcaps)) OR ((folbee) AND > > (ar)) OR ((biotin) AND (forte)) OR ((nephplex) AND (rx)) OR > > ((protegra)) OR ((poly‐vit) AND (chew)) OR ((vitamin) AND > > (b‐100)) OR ((vitamins) AND (for) AND (hair)) OR ((vicam)) OR > > ((renatabs)) OR ((fabb)) OR ((rena‐vite)) OR ((infuvite)) OR > > ((cota‐b‐plex)) OR ((poly) AND (vit) AND (with) AND > > (infant) AND (drop)) OR ((vitacirc‐b)) OR ((nephrocaps) AND > > (qt)) OR ((l‐methyl‐b6‐b12)) OR ((bounty) AND (bear) > > AND (vitamins)) OR ((folic) AND (acid/vitamin) AND b AND > > (complex/vitamin) AND (c)) OR ((mega) AND (b)) OR ((vitamin) AND > > (liquid)) OR ((tri‐vit) AND (drops)) OR ((vitamin) AND (a) AND > > d AND (softgels)) OR ((apatate)) OR ((high) AND (potency) AND (b+c)) > > OR ((t‐vites)) OR ((b‐plex)) OR ((combgen)) OR > > ((vita‐respa)) OR ((folamin)) OR ((foltrate)) OR ((stress) AND b > > AND (with) AND (c)) OR ((l‐methylfolate) AND (ca,) AND > > (me‐cbl) AND (nac)) OR ((surbex)) OR ((triveen‐cf)) OR > > ((renaphro)) OR ((one‐a‐day) AND (essentials)) OR > > ((sunkist) AND (child) AND (chewable) AND (with) AND (c)) OR ((one) > > AND (daily)) OR ((vesselvite)) OR ((b‐ject) AND (100)) OR > > ((enfolast‐n)) OR ((folbee) AND (plus)) OR ((folastin)) OR > > ((therobec)) OR ((theragenerix)) OR ((megaton)) OR ((tri‐vit)) OR > > ((enfolast)) OR ((dialyvite) AND (rx)) OR ((renal) AND (caps)) OR > > ((b‐plex) AND (plus)) OR ((tri‐vita) AND (drops)) OR > > ((vi‐stress)) OR ((d‐400) AND (international) AND (units)) > > OR ((tab‐a‐vite)) OR ((b) AND (complex)) OR > > ((vol‐care) AND (rx)) OR ((folast)) OR ((protegra) AND (cardio)) > > OR ((folic) AND (acid/cyanocobalamin/pyridoxine) AND (hydrochloride)) OR > > ((vita) AND (drop)) OR ((vitamin) AND (a,) AND (d)) OR > > ((rovin‐cf)) OR ((apetigen)) OR ((folbalin)) OR > > ((key‐plex)) OR ((b‐scorbic)) OR ((surbex‐t)) OR > > ((cardiotek)) OR ((multiple) AND (vitamins) AND (essentials)) OR > > ((vitaplex)) OR ((morplex)) OR ((balanced) AND (b‐50)) OR > > ((folplex)) OR ((glutofac)) OR ((cardiotek) AND (rx)) OR ((oncovite)) > > OR ((surbex) AND (with) AND (c)) OR ((vi‐daylin) AND (drops)) OR > > ((scotts) AND (emulsion)) OR ((vitamin) AND b AND (complex) AND > > (with) AND (vitamin) AND (c) AND (b12)) OR ((cod) AND (liver) AND > > (oil) AND (mint)) OR ((vitamin) AND b AND (complex) AND (with) AND > > (b12)) OR ((lipoflavonoid)) OR ((neurpath‐b)) OR > > ((b‐complex) AND (50)) OR ((foltabs) AND (800)) OR > > ((therapeutic) AND (vitamins)) OR ((folbalin) AND (plus)) OR > > ((allbee‐c) AND (800)) OR ((allbee‐c)) OR ((zycose)) OR > > ((diatx)) OR ((theragran)) OR ((sesame) AND (st.) AND (vitamins) AND > > (with) AND (extra) AND (c)) OR ((folgard) AND ((obsolete))) OR > > ((nephrocaps)) OR ((multivitamin)) OR ((flintstones) AND > > (multivitamins)) OR ((folgard) AND (rx)) OR ((vitamin) AND b AND > > (complex) AND (100)) OR ((cefol)) OR ((super) AND b AND (complex) AND > > (with) AND (c)) OR ((flintstones) AND (with) AND c AND > > (multivitamins)) OR ((tl) AND (gard)) OR ((daily) AND (multiple) AND > > (vitamins)) OR ((superplex‐t)) OR ((foleve)) OR ((thex) AND > > (forte)) OR ((m.v.i.) AND (pediatric)) OR ((vigomar) AND (forte)) OR > > ((super) AND (plenamins)) OR ((ivites) AND (rx)) OR ((multi) AND > > (vits) AND (with) AND (beta) AND (carotene)) OR ((allantex)) OR > > ((foleve) AND (plus)) OR ((b) AND (complex) AND (50)) OR > > ((nephro‐vite) AND (rx)) OR ((vitamin) AND b AND (complex) AND > > (t/r)) OR ((dayalets)) OR ((b‐complex)) OR ((cerefolinnac)) OR > > ((niafol)) OR ((folbic)) OR ((super) AND (aytinal) AND (50) AND > > (plus)) OR ((farbee) AND (with) AND (c)) OR ((garfield) AND > > (vitamins) AND (with) AND (c)) OR ((b) AND (100) AND (complex)) OR > > ((sigtab)) OR ((vimar)) OR ((folnate) AND (plus)) OR > > ((daily‐vite) AND (men's) AND (formula)) OR ((cernevit)) OR > > ((l‐methylfolate) AND (ca,) AND (p‐5‐p,) AND > > (me‐cbl)) OR ((vi‐daylin) AND (chewable)) OR ((mtx) AND > > (support)) OR ((may‐vita)) OR ((stress) AND (formula) AND (600)) > > OR ((bee) AND (with) AND (c)) OR ((child) AND (circus)) OR > > ((berocca)) OR ((stress) AND (formula) AND (caplets)) OR > > ((thera‐plus)) OR ((daily) AND (vite)) OR ((multi‐delyn)) > > OR ((m.v.c.) AND (sdv)) OR ((kenwood) AND (therapeutic)) OR > > ((b‐complex) AND (sr)) OR ((folplex) AND (2.2)) OR ((vitamin) > > AND (daily) AND (liquid)) OR ((bugs) AND (bunny) AND (with) AND > > (extra) AND (c)) OR ((folnate)) OR ((b‐50) AND (complex)) OR > > ((therapeutic) AND (b+c)) OR ((children's) AND (chewable) AND > > (multivitamins)) OR ((theravite)) OR ((vitamin) AND (b‐50)) OR > > ((high) AND (potency) AND b AND (complex) AND (with) AND (b12) AND > > (c)) OR ((nufol)) OR ((m.v.i.) AND (adult)) OR > > ((one‐a‐day) AND (men's) AND (health) AND (formula)) OR > > ((b‐stress)) OR ((chewable) AND (vitamins)) OR > > ((uni‐daily)) OR ((folgard) AND (rx) AND (2.2)) OR > > ((vi‐daylin)) OR ((super) AND b AND (complex)) OR ((apetex)) OR > > ((unicap) AND (jr.)) OR ((chewable‐vite)) OR ((multi‐day)) > > OR ((b‐complex) AND (with) AND (b‐12)) OR > > ((optilets‐500)) OR ((vitabee) AND (with) AND (c)) OR > > ((nutrifac) AND (zx)) OR ((thera)) OR ((dexfol)) OR ((garfield) AND > > (vitamins)) OR ((animal) AND (shape) AND (vitamins)) OR ((zymacap)) OR > > ((one) AND (tab) AND (daily)) OR ((menopause) AND (relief) AND (with) > > AND (lifenol)) OR ((stress) AND (formula)) OR ((cernevit‐12)) OR > > ((vitamin) AND (b+c)) OR ((essential) AND (balance)) OR ((prostate) > > AND (2.4)) OR ((metanx)) OR ((super) AND (b‐50)) OR ((infuvite) > > AND (pediatric)) OR ((b‐50) AND (balanced)) OR ((land) AND > > (before) AND (time) AND (children's) AND (with) AND (vitamin) AND > > (c)) OR ((balanced) AND (b‐100) AND (time) AND (released) AND > > (high) AND (potency) AND (caplets)) OR ((pyridoxine) AND > > (cyanocobalamin) AND (folic) AND (acid)) OR ((folbic)))" > > } > > } > > ], > > "cutoff\_frequency" : 0.001 > > } > > }, > > "sort": [{{@SORTQUERY}}], > > "facets": {{@FACETQUERY}} > > } > > } > > } > > > > Thanks, > > Franklin > > > > -- > > You received this message because you are subscribed to the Google Groups > > "elasticsearch" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Maria\_John\_Franklin](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@Maria\_John\_Franklin](https://discuss.elastic.co/u/Maria_John_Franklin)\ **Post date:** [May 28, 2013, 3:09pm UTC](https://discuss.elastic.co/t/search-performance-issue/12036/8 "2013-05-28T15:09:17Z")
On Tuesday, May 28, 2013 9:04:46 PM UTC+8, simonw wrote: > filters won't help here. Can you provide some info how slow the query is? > I mean what is the usecase for this query, are you doing patent searches? I > really can't see how can make this fast really. The only think I can think > of is to change the structure entirely but without usecase hard to tell. > > simon > > On Tuesday, May 28, 2013 2:23:01 PM UTC+2, Nicolas Labrot wrote: > > > You shoud try to use filter instead of query. I don't think a score is > > relevant with this type of query. > > > > On Tue, May 28, 2013 at 1:22 PM, Maria John Franklin \< > > [mariajoh...@mycura.com](mailto:mariajoh...@mycura.com)\> wrote: > > > > > On Monday, May 20, 2013 6:22:34 PM UTC+8, Maria John Franklin wrote: > > > > > > > Hi Friends, > > > > > > > > ``` > > > > Elastic search Performance is very slow when i add multiple OR > > > > > > > > ``` > > > > > > > > condition in query string..How to manage that one? > > > > > > > > # Example > > > > > > > > ( Discover OR the OR concepts OR and OR \*\*experiments OR that OR > > > > define OR the OR \*\*fields OR of OR genetics OR molecular .....etc) > > > > > > > > Thanks, > > > > Franklin > > > > > > Hi Simonw, > > > This is my exact query..How to increase performance in this query? > > > > > > { > > > "from": 0, > > > "size": 10, > > > "fields" :["test","test1","test2","\*\*test3","test4"], > > > "query": { > > > "bool": { > > > "must": [ > > > { > > > "query\_string": { > > > "query": "(((ascorbic) AND (acid,) AND (folic) AND (acid,) AND > > > (niacin,) AND (thiamine,) AND (riboflavin,) AND (pyridoxine,) AND > > > (cyanocobalamin,) AND (pantothenic) AND (acid,) AND (biotin)) OR > > > ((nephrocaps)) OR ((multivitamin)) OR ((folbee)) OR ((vitamin) AND b > > > AND (complex) AND (injectable)) OR ((therems)) OR ((rena‐vite) > > > AND (rx)) OR ((unicap)) OR ((1000) AND (bc)) OR ((lipotriad)) OR > > > ((vitamin) AND b AND (complex)) OR ((vitamin) AND (b‐100) AND > > > (t/r)) OR ((bee‐comp) AND (with) AND (c)) OR ((folmor)) OR > > > ((nephro‐vite)) OR ((balanced) AND (b‐150)) OR > > > ((vita‐ret) AND (500)) OR ((neuroforte‐six)) OR > > > ((poly‐vi‐sol) AND (drops)) OR ((tri‐vi‐sol)) OR > > > ((super) AND (b‐100) AND (td)) OR ((balanced) AND (b‐100)) > > > OR ((m.v.i.‐12)) OR ((foltx)) OR ((nephrolan) AND (rx)) OR > > > ((cod) AND (liver) AND (oil)) OR ((baby) AND (vitamin) AND (drop)) OR > > > ((equaline) AND (one) AND (daily) AND (essential)) OR ((lipogen)) OR > > > ((triphro)) OR ((formula) AND (b)) OR ((poly‐vi‐sol)) OR > > > ((vitamin) AND b AND (complex) AND (with) AND (c)) OR ((liponol)) OR > > > ((hexavitamin)) OR ((cholinoid)) OR ((one‐a‐day) AND (50+)) > > > OR ((high) AND b AND (complex)) OR ((cerefolin)) OR ((vitamin) AND > > > (c,) AND (e,) AND (rose) AND (hips)) OR ((cholidase)) OR ((poly) AND > > > (vit) AND (drops)) OR ((sunkist) AND (child) AND (chewable)) OR > > > ((nephronex)) OR ((alz‐nac)) OR ((dialyvite) AND (800)) OR > > > ((beminal‐500)) OR ((cardiotek‐rx)) OR ((poly‐vita) > > > AND (drops)) OR ((reno) AND (caps)) OR ((stresstabs)) OR ((primaplex)) > > > OR ((becomject‐100)) OR ((balanced) AND (b‐100) AND (high) > > > AND (potency) AND (caplets)) OR ((super) AND (aytinal) AND (for) AND > > > (active) AND (adults)) OR ((vitamin) AND b AND (complex) AND (with) > > > AND (vitamin) AND (c)) OR ((vitamin) AND (b‐plex)) OR > > > ((vi‐daylin) AND (adc)) OR ((neurodep)) OR ((unicap) AND > > > (capsule)) OR ((fruity) AND (chew)) OR ((folcaps)) OR ((folbee) AND > > > (ar)) OR ((biotin) AND (forte)) OR ((nephplex) AND (rx)) OR > > > ((protegra)) OR ((poly‐vit) AND (chew)) OR ((vitamin) AND > > > (b‐100)) OR ((vitamins) AND (for) AND (hair)) OR ((vicam)) OR > > > ((renatabs)) OR ((fabb)) OR ((rena‐vite)) OR ((infuvite)) OR > > > ((cota‐b‐plex)) OR ((poly) AND (vit) AND (with) AND > > > (infant) AND (drop)) OR ((vitacirc‐b)) OR ((nephrocaps) AND > > > (qt)) OR ((l‐methyl‐b6‐b12)) OR ((bounty) AND (bear) > > > AND (vitamins)) OR ((folic) AND (acid/vitamin) AND b AND > > > (complex/vitamin) AND (c)) OR ((mega) AND (b)) OR ((vitamin) AND > > > (liquid)) OR ((tri‐vit) AND (drops)) OR ((vitamin) AND (a) AND > > > d AND (softgels)) OR ((apatate)) OR ((high) AND (potency) AND (b+c)) > > > OR ((t‐vites)) OR ((b‐plex)) OR ((combgen)) OR > > > ((vita‐respa)) OR ((folamin)) OR ((foltrate)) OR ((stress) AND b > > > AND (with) AND (c)) OR ((l‐methylfolate) AND (ca,) AND > > > (me‐cbl) AND (nac)) OR ((surbex)) OR ((triveen‐cf)) OR > > > ((renaphro)) OR ((one‐a‐day) AND (essentials)) OR > > > ((sunkist) AND (child) AND (chewable) AND (with) AND (c)) OR ((one) > > > AND (daily)) OR ((vesselvite)) OR ((b‐ject) AND (100)) OR > > > ((enfolast‐n)) OR ((folbee) AND (plus)) OR ((folastin)) OR > > > ((therobec)) OR ((theragenerix)) OR ((megaton)) OR ((tri‐vit)) OR > > > ((enfolast)) OR ((dialyvite) AND (rx)) OR ((renal) AND (caps)) OR > > > ((b‐plex) AND (plus)) OR ((tri‐vita) AND (drops)) OR > > > ((vi‐stress)) OR ((d‐400) AND (international) AND (units)) > > > OR ((tab‐a‐vite)) OR ((b) AND (complex)) OR > > > ((vol‐care) AND (rx)) OR ((folast)) OR ((protegra) AND (cardio)) > > > OR ((folic) AND (acid/cyanocobalamin/pyridoxine) AND (hydrochloride)) OR > > > ((vita) AND (drop)) OR ((vitamin) AND (a,) AND (d)) OR > > > ((rovin‐cf)) OR ((apetigen)) OR ((folbalin)) OR > > > ((key‐plex)) OR ((b‐scorbic)) OR ((surbex‐t)) OR > > > ((cardiotek)) OR ((multiple) AND (vitamins) AND (essentials)) OR > > > ((vitaplex)) OR ((morplex)) OR ((balanced) AND (b‐50)) OR > > > ((folplex)) OR ((glutofac)) OR ((cardiotek) AND (rx)) OR ((oncovite)) > > > OR ((surbex) AND (with) AND (c)) OR ((vi‐daylin) AND (drops)) OR > > > ((scotts) AND (emulsion)) OR ((vitamin) AND b AND (complex) AND > > > (with) AND (vitamin) AND (c) AND (b12)) OR ((cod) AND (liver) AND > > > (oil) AND (mint)) OR ((vitamin) AND b AND (complex) AND (with) AND > > > (b12)) OR ((lipoflavonoid)) OR ((neurpath‐b)) OR > > > ((b‐complex) AND (50)) OR ((foltabs) AND (800)) OR > > > ((therapeutic) AND (vitamins)) OR ((folbalin) AND (plus)) OR > > > ((allbee‐c) AND (800)) OR ((allbee‐c)) OR ((zycose)) OR > > > ((diatx)) OR ((theragran)) OR ((sesame) AND (st.) AND (vitamins) AND > > > (with) AND (extra) AND (c)) OR ((folgard) AND ((obsolete))) OR > > > ((nephrocaps)) OR ((multivitamin)) OR ((flintstones) AND > > > (multivitamins)) OR ((folgard) AND (rx)) OR ((vitamin) AND b AND > > > (complex) AND (100)) OR ((cefol)) OR ((super) AND b AND (complex) AND > > > (with) AND (c)) OR ((flintstones) AND (with) AND c AND > > > (multivitamins)) OR ((tl) AND (gard)) OR ((daily) AND (multiple) AND > > > (vitamins)) OR ((superplex‐t)) OR ((foleve)) OR ((thex) AND > > > (forte)) OR ((m.v.i.) AND (pediatric)) OR ((vigomar) AND (forte)) OR > > > ((super) AND (plenamins)) OR ((ivites) AND (rx)) OR ((multi) AND > > > (vits) AND (with) AND (beta) AND (carotene)) OR ((allantex)) OR > > > ((foleve) AND (plus)) OR ((b) AND (complex) AND (50)) OR > > > ((nephro‐vite) AND (rx)) OR ((vitamin) AND b AND (complex) AND > > > (t/r)) OR ((dayalets)) OR ((b‐complex)) OR ((cerefolinnac)) OR > > > ((niafol)) OR ((folbic)) OR ((super) AND (aytinal) AND (50) AND > > > (plus)) OR ((farbee) AND (with) AND (c)) OR ((garfield) AND > > > (vitamins) AND (with) AND (c)) OR ((b) AND (100) AND (complex)) OR > > > ((sigtab)) OR ((vimar)) OR ((folnate) AND (plus)) OR > > > ((daily‐vite) AND (men's) AND (formula)) OR ((cernevit)) OR > > > ((l‐methylfolate) AND (ca,) AND (p‐5‐p,) AND > > > (me‐cbl)) OR ((vi‐daylin) AND (chewable)) OR ((mtx) AND > > > (support)) OR ((may‐vita)) OR ((stress) AND (formula) AND (600)) > > > OR ((bee) AND (with) AND (c)) OR ((child) AND (circus)) OR > > > ((berocca)) OR ((stress) AND (formula) AND (caplets)) OR > > > ((thera‐plus)) OR ((daily) AND (vite)) OR ((multi‐delyn)) > > > OR ((m.v.c.) AND (sdv)) OR ((kenwood) AND (therapeutic)) OR > > > ((b‐complex) AND (sr)) OR ((folplex) AND (2.2)) OR ((vitamin) > > > AND (daily) AND (liquid)) OR ((bugs) AND (bunny) AND (with) AND > > > (extra) AND (c)) OR ((folnate)) OR ((b‐50) AND (complex)) OR > > > ((therapeutic) AND (b+c)) OR ((children's) AND (chewable) AND > > > (multivitamins)) OR ((theravite)) OR ((vitamin) AND (b‐50)) OR > > > ((high) AND (potency) AND b AND (complex) AND (with) AND (b12) AND > > > (c)) OR ((nufol)) OR ((m.v.i.) AND (adult)) OR > > > ((one‐a‐day) AND (men's) AND (health) AND (formula)) OR > > > ((b‐stress)) OR ((chewable) AND (vitamins)) OR > > > ((uni‐daily)) OR ((folgard) AND (rx) AND (2.2)) OR > > > ((vi‐daylin)) OR ((super) AND b AND (complex)) OR ((apetex)) OR > > > ((unicap) AND (jr.)) OR ((chewable‐vite)) OR ((multi‐day)) > > > OR ((b‐complex) AND (with) AND (b‐12)) OR > > > ((optilets‐500)) OR ((vitabee) AND (with) AND (c)) OR > > > ((nutrifac) AND (zx)) OR ((thera)) OR ((dexfol)) OR ((garfield) AND > > > (vitamins)) OR ((animal) AND (shape) AND (vitamins)) OR ((zymacap)) OR > > > ((one) AND (tab) AND (daily)) OR ((menopause) AND (relief) AND (with) > > > AND (lifenol)) OR ((stress) AND (formula)) OR ((cernevit‐12)) OR > > > ((vitamin) AND (b+c)) OR ((essential) AND (balance)) OR ((prostate) > > > AND (2.4)) OR ((metanx)) OR ((super) AND (b‐50)) OR ((infuvite) > > > AND (pediatric)) OR ((b‐50) AND (balanced)) OR ((land) AND > > > (before) AND (time) AND (children's) AND (with) AND (vitamin) AND > > > (c)) OR ((balanced) AND (b‐100) AND (time) AND (released) AND > > > (high) AND (potency) AND (caplets)) OR ((pyridoxine) AND > > > (cyanocobalamin) AND (folic) AND (acid)) OR ((folbic)))" > > > } > > > } > > > ], > > > "cutoff\_frequency" : 0.001 > > > } > > > }, > > > "sort": [{{@SORTQUERY}}], > > > "facets": {{@FACETQUERY}} > > > } > > > } > > > } > > > > > > Thanks, > > > Franklin > > > > > > -- > > > You received this message because you are subscribed to the Google > > > Groups "elasticsearch" group. > > > To unsubscribe from this group and stop receiving emails from it, send > > > an email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ``` Hi Friends, My search Fuctionality having two type. ``` 1. type 1----taking only few seconds { "from": 0, "size": 10, "fields" :["test","test1","test2","\*\*test3","test4"], "query": { "bool": { "must": [ { "query\_string": { "query": "(test)" } } ] ``` } ``` }, "sort": [{{@SORTQUERY}}], "facets": {{@FACETQUERY}} } } } 1. Type 2----taking 1 minute..how can i reduce this timing?. { "from": 0, "size": 10, "fields" :["test","test1","test2","\*\*test3","test4"], "query": { "bool": { "must": [ { "query\_string": { "query": "(((ascorbic) AND (acid,) AND (folic) AND (acid,) AND (niacin,) AND (thiamine,) AND (riboflavin,) AND (pyridoxine,) AND (cyanocobalamin,) AND (pantothenic) AND (acid,) AND (biotin)) OR ((nephrocaps)) OR ((multivitamin)) OR ((folbee)) OR ((vitamin) AND b AND (complex) AND (injectable)) OR ((therems)) OR ((rena‐vite) AND (rx)) OR ((unicap)) OR ((1000) AND (bc)) OR ((lipotriad)) OR ((vitamin) AND b AND (complex)) OR ((vitamin) AND (b‐100) AND (t/r)) OR ((bee‐comp) AND (with) AND (c)) OR ((folmor)) OR ((nephro‐vite)) OR ((balanced) AND (b‐150)) OR ((vita‐ret) AND (500)) OR ((neuroforte‐six)) OR ((poly‐vi‐sol) AND (drops)) OR ((tri‐vi‐sol)) OR ((super) AND (b‐100) AND (td)) OR ((balanced) AND (b‐100)) OR ((m.v.i.‐12)) OR ((foltx)) OR ((nephrolan) AND (rx)) OR ((cod) AND (liver) AND (oil)) OR ((baby) AND (vitamin) AND (drop)) OR ((equaline) AND (one) AND (daily) AND (essential)) OR ((lipogen)) OR ((triphro)) OR ((formula) AND (b)) OR ((poly‐vi‐sol)) OR ((vitamin) AND b AND (complex) AND (with) AND (c)) OR ((liponol)) OR ((hexavitamin)) OR ((cholinoid)) OR ((one‐a‐day) AND (50+)) OR ((high) AND b AND (complex)) OR ((cerefolin)) OR ((vitamin) AND (c,) AND (e,) AND (rose) AND (hips)) OR ((cholidase)) OR ((poly) AND (vit) AND (drops)) OR ((sunkist) AND (child) AND (chewable)) OR ((nephronex)) OR ((alz‐nac)) OR ((dialyvite) AND (800)) OR ((beminal‐500)) OR ((cardiotek‐rx)) OR ((poly‐vita) AND (drops)) OR ((reno) AND (caps)) OR ((stresstabs)) OR ((primaplex)) OR ((becomject‐100)) OR ((balanced) AND (b‐100) AND (high) AND (potency) AND (caplets)) OR ((super) AND (aytinal) AND (for) AND (active) AND (adults)) OR ((vitamin) AND b AND (complex) AND (with) AND (vitamin) AND (c)) OR ((vitamin) AND (b‐plex)) OR ((vi‐daylin) AND (adc)) OR ((neurodep)) OR ((unicap) AND (capsule)) OR ((fruity) AND (chew)) OR ((folcaps)) OR ((folbee) AND (ar)) OR ((biotin) AND (forte)) OR ((nephplex) AND (rx)) OR ((protegra)) OR ((poly‐vit) AND (chew)) OR ((vitamin) AND (b‐100)) OR ((vitamins) AND (for) AND (hair)) OR ((vicam)) OR ((renatabs)) OR ((fabb)) OR ((rena‐vite)) OR ((infuvite)) OR ((cota‐b‐plex)) OR ((poly) AND (vit) AND (with) AND (infant) AND (drop)) OR ((vitacirc‐b)) OR ((nephrocaps) AND (qt)) OR ((l‐methyl‐b6‐b12)) OR ((bounty) AND (bear) AND (vitamins)) OR ((folic) AND (acid/vitamin) AND b AND (complex/vitamin) AND (c)) OR ((mega) AND (b)) OR ((vitamin) AND (liquid)) OR ((tri‐vit) AND (drops)) OR ((vitamin) AND (a) AND d AND (softgels)) OR ((apatate)) OR ((high) AND (potency) AND (b+c)) OR ((t‐vites)) OR ((b‐plex)) OR ((combgen)) OR ((vita‐respa)) OR ((folamin)) OR ((foltrate)) OR ((stress) AND b AND (with) AND (c)) OR ((l‐methylfolate) AND (ca,) AND (me‐cbl) AND (nac)) OR ((surbex)) OR ((triveen‐cf)) OR ((renaphro)) OR ((one‐a‐day) AND (essentials)) OR ((sunkist) AND (child) AND (chewable) AND (with) AND (c)) OR ((one) AND (daily)) OR ((vesselvite)) OR ((b‐ject) AND (100)) OR ((enfolast‐n)) OR ((folbee) AND (plus)) OR ((folastin)) OR ((therobec)) OR ((theragenerix)) OR ((megaton)) OR ((tri‐vit)) OR ((enfolast)) OR ((dialyvite) AND (rx)) OR ((renal) AND (caps)) OR ((b‐plex) AND (plus)) OR ((tri‐vita) AND (drops)) OR ((vi‐stress)) OR ((d‐400) AND (international) AND (units)) OR ((tab‐a‐vite)) OR ((b) AND (complex)) OR ((vol‐care) AND (rx)) OR ((folast)) OR ((protegra) AND (cardio)) OR ((folic) AND (acid/cyanocobalamin/pyridoxine) AND (hydrochloride)) OR ((vita) AND (drop)) OR ((vitamin) AND (a,) AND (d)) OR ((rovin‐cf)) OR ((apetigen)) OR ((folbalin)) OR ((key‐plex)) OR ((b‐scorbic)) OR ((surbex‐t)) OR ((cardiotek)) OR ((multiple) AND (vitamins) AND (essentials)) OR ((vitaplex)) OR ((morplex)) OR ((balanced) AND (b‐50)) OR ((folplex)) OR ((glutofac)) OR ((cardiotek) AND (rx)) OR ((oncovite)) OR ((surbex) AND (with) AND (c)) OR ((vi‐daylin) AND (drops)) OR ((scotts) AND (emulsion)) OR ((vitamin) AND b AND (complex) AND (with) AND (vitamin) AND (c) AND (b12)) OR ((cod) AND (liver) AND (oil) AND (mint)) OR ((vitamin) AND b AND (complex) AND (with) AND (b12)) OR ((lipoflavonoid)) OR ((neurpath‐b)) OR ((b‐complex) AND (50)) OR ((foltabs) AND (800)) OR ((therapeutic) AND (vitamins)) OR ((folbalin) AND (plus)) OR ((allbee‐c) AND (800)) OR ((allbee‐c)) OR ((zycose)) OR ((diatx)) OR ((theragran)) OR ((sesame) AND (st.) AND (vitamins) AND (with) AND (extra) AND (c)) OR ((folgard) AND ((obsolete))) OR ((nephrocaps)) OR ((multivitamin)) OR ((flintstones) AND (multivitamins)) OR ((folgard) AND (rx)) OR ((vitamin) AND b AND (complex) AND (100)) OR ((cefol)) OR ((super) AND b AND (complex) AND (with) AND (c)) OR ((flintstones) AND (with) AND c AND (multivitamins)) OR ((tl) AND (gard)) OR ((daily) AND (multiple) AND (vitamins)) OR ((superplex‐t)) OR ((foleve)) OR ((thex) AND (forte)) OR ((m.v.i.) AND (pediatric)) OR ((vigomar) AND (forte)) OR ((super) AND (plenamins)) OR ((ivites) AND (rx)) OR ((multi) AND (vits) AND (with) AND (beta) AND (carotene)) OR ((allantex)) OR ((foleve) AND (plus)) OR ((b) AND (complex) AND (50)) OR ((nephro‐vite) AND (rx)) OR ((vitamin) AND b AND (complex) AND (t/r)) OR ((dayalets)) OR ((b‐complex)) OR ((cerefolinnac)) OR ((niafol)) OR ((folbic)) OR ((super) AND (aytinal) AND (50) AND (plus)) OR ((farbee) AND (with) AND (c)) OR ((garfield) AND (vitamins) AND (with) AND (c)) OR ((b) AND (100) AND (complex)) OR ((sigtab)) OR ((vimar)) OR ((folnate) AND (plus)) OR ((daily‐vite) AND (men's) AND (formula)) OR ((cernevit)) OR ((l‐methylfolate) AND (ca,) AND (p‐5‐p,) AND (me‐cbl)) OR ((vi‐daylin) AND (chewable)) OR ((mtx) AND (support)) OR ((may‐vita)) OR ((stress) AND (formula) AND (600)) OR ((bee) AND (with) AND (c)) OR ((child) AND (circus)) OR ((berocca)) OR ((stress) AND (formula) AND (caplets)) OR ((thera‐plus)) OR ((daily) AND (vite)) OR ((multi‐delyn)) OR ((m.v.c.) AND (sdv)) OR ((kenwood) AND (therapeutic)) OR ((b‐complex) AND (sr)) OR ((folplex) AND (2.2)) OR ((vitamin) AND (daily) AND (liquid)) OR ((bugs) AND (bunny) AND (with) AND (extra) AND (c)) OR ((folnate)) OR ((b‐50) AND (complex)) OR ((therapeutic) AND (b+c)) OR ((children's) AND (chewable) AND (multivitamins)) OR ((theravite)) OR ((vitamin) AND (b‐50)) OR ((high) AND (potency) AND b AND (complex) AND (with) AND (b12) AND (c)) OR ((nufol)) OR ((m.v.i.) AND (adult)) OR ((one‐a‐day) AND (men's) AND (health) AND (formula)) OR ((b‐stress)) OR ((chewable) AND (vitamins)) OR ((uni‐daily)) OR ((folgard) AND (rx) AND (2.2)) OR ((vi‐daylin)) OR ((super) AND b AND (complex)) OR ((apetex)) OR ((unicap) AND (jr.)) OR ((chewable‐vite)) OR ((multi‐day)) OR ((b‐complex) AND (with) AND (b‐12)) OR ((optilets‐500)) OR ((vitabee) AND (with) AND (c)) OR ((nutrifac) AND (zx)) OR ((thera)) OR ((dexfol)) OR ((garfield) AND (vitamins)) OR ((animal) AND (shape) AND (vitamins)) OR ((zymacap)) OR ((one) AND (tab) AND (daily)) OR ((menopause) AND (relief) AND (with) AND (lifenol)) OR ((stress) AND (formula)) OR ((cernevit‐12)) OR ((vitamin) AND (b+c)) OR ((essential) AND (balance)) OR ((prostate) AND (2.4)) OR ((metanx)) OR ((super) AND (b‐50)) OR ((infuvite) AND (pediatric)) OR ((b‐50) AND (balanced)) OR ((land) AND (before) AND (time) AND (children's) AND (with) AND (vitamin) AND (c)) OR ((balanced) AND (b‐100) AND (time) AND (released) AND (high) AND (potency) AND (caplets)) OR ((pyridoxine) AND (cyanocobalamin) AND (folic) AND (acid)) OR ((folbic)))" } } ] } }, "sort": [{{@SORTQUERY}}], "facets": {{@FACETQUERY}} } } } Thanks, Franklin > > > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Maria\_John\_Franklin](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@Maria\_John\_Franklin](https://discuss.elastic.co/u/Maria_John_Franklin)\ **Post date:** [May 29, 2013, 2:58am UTC](https://discuss.elastic.co/t/search-performance-issue/12036/9 "2013-05-29T02:58:16Z")
On Monday, May 20, 2013 6:22:34 PM UTC+8, Maria John Franklin wrote: > Hi Friends, > > ``` > Elastic search Performance is very slow when i add multiple OR > > ``` > > condition in query string..How to manage that one? > > # Example > > ( Discover OR the OR concepts OR and OR experiments OR that OR > define OR the OR fields OR of OR genetics OR molecular .....etc) > > Thanks, > Franklin _Hi_ simonw, This is not Patent Search..But my _functionality is also same like patent search._ _Thanks_ _Franklin_ -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Nicolas\_Labrot](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nicolas_labrot/32/2177_2.png) [@Nicolas\_Labrot](https://discuss.elastic.co/u/Nicolas_Labrot)\ **Post date:** [May 29, 2013, 6:33am UTC](https://discuss.elastic.co/t/search-performance-issue/12036/10 "2013-05-29T06:33:26Z")
Le mardi 28 mai 2013 15:04:46 UTC+2, simonw a écrit : > filters won't help here. Can you provide some info how slow the query is? > I mean what is the usecase for this query, are you doing patent searches? I > really can't see how can make this fast really. The only think I can think > of is to change the structure entirely but without usecase hard to tell. Why filter won't help? I'm wondering if scoring for this type of query can have a noticeable cost > simon > > On Tuesday, May 28, 2013 2:23:01 PM UTC+2, Nicolas Labrot wrote: > > > You shoud try to use filter instead of query. I don't think a score is > > relevant with this type of query. > > > > On Tue, May 28, 2013 at 1:22 PM, Maria John Franklin \< > > [mariajoh...@mycura.com](mailto:mariajoh...@mycura.com)\> wrote: > > > > > On Monday, May 20, 2013 6:22:34 PM UTC+8, Maria John Franklin wrote: > > > > > > > Hi Friends, > > > > > > > > ``` > > > > Elastic search Performance is very slow when i add multiple OR > > > > > > > > ``` > > > > > > > > condition in query string..How to manage that one? > > > > > > > > # Example > > > > > > > > ( Discover OR the OR concepts OR and OR \*\*experiments OR that OR > > > > define OR the OR \*\*fields OR of OR genetics OR molecular .....etc) > > > > > > > > Thanks, > > > > Franklin > > > > > > Hi Simonw, > > > This is my exact query..How to increase performance in this query? > > > > > > { > > > "from": 0, > > > "size": 10, > > > "fields" :["test","test1","test2","\*\*test3","test4"], > > > "query": { > > > "bool": { > > > "must": [ > > > { > > > "query\_string": { > > > "query": "(((ascorbic) AND (acid,) AND (folic) AND (acid,) AND > > > (niacin,) AND (thiamine,) AND (riboflavin,) AND (pyridoxine,) AND > > > (cyanocobalamin,) AND (pantothenic) AND (acid,) AND (biotin)) OR > > > ((nephrocaps)) OR ((multivitamin)) OR ((folbee)) OR ((vitamin) AND b > > > AND (complex) AND (injectable)) OR ((therems)) OR ((rena‐vite) > > > AND (rx)) OR ((unicap)) OR ((1000) AND (bc)) OR ((lipotriad)) OR > > > ((vitamin) AND b AND (complex)) OR ((vitamin) AND (b‐100) AND > > > (t/r)) OR ((bee‐comp) AND (with) AND (c)) OR ((folmor)) OR > > > ((nephro‐vite)) OR ((balanced) AND (b‐150)) OR > > > ((vita‐ret) AND (500)) OR ((neuroforte‐six)) OR > > > ((poly‐vi‐sol) AND (drops)) OR ((tri‐vi‐sol)) OR > > > ((super) AND (b‐100) AND (td)) OR ((balanced) AND (b‐100)) > > > OR ((m.v.i.‐12)) OR ((foltx)) OR ((nephrolan) AND (rx)) OR > > > ((cod) AND (liver) AND (oil)) OR ((baby) AND (vitamin) AND (drop)) OR > > > ((equaline) AND (one) AND (daily) AND (essential)) OR ((lipogen)) OR > > > ((triphro)) OR ((formula) AND (b)) OR ((poly‐vi‐sol)) OR > > > ((vitamin) AND b AND (complex) AND (with) AND (c)) OR ((liponol)) OR > > > ((hexavitamin)) OR ((cholinoid)) OR ((one‐a‐day) AND (50+)) > > > OR ((high) AND b AND (complex)) OR ((cerefolin)) OR ((vitamin) AND > > > (c,) AND (e,) AND (rose) AND (hips)) OR ((cholidase)) OR ((poly) AND > > > (vit) AND (drops)) OR ((sunkist) AND (child) AND (chewable)) OR > > > ((nephronex)) OR ((alz‐nac)) OR ((dialyvite) AND (800)) OR > > > ((beminal‐500)) OR ((cardiotek‐rx)) OR ((poly‐vita) > > > AND (drops)) OR ((reno) AND (caps)) OR ((stresstabs)) OR ((primaplex)) > > > OR ((becomject‐100)) OR ((balanced) AND (b‐100) AND (high) > > > AND (potency) AND (caplets)) OR ((super) AND (aytinal) AND (for) AND > > > (active) AND (adults)) OR ((vitamin) AND b AND (complex) AND (with) > > > AND (vitamin) AND (c)) OR ((vitamin) AND (b‐plex)) OR > > > ((vi‐daylin) AND (adc)) OR ((neurodep)) OR ((unicap) AND > > > (capsule)) OR ((fruity) AND (chew)) OR ((folcaps)) OR ((folbee) AND > > > (ar)) OR ((biotin) AND (forte)) OR ((nephplex) AND (rx)) OR > > > ((protegra)) OR ((poly‐vit) AND (chew)) OR ((vitamin) AND > > > (b‐100)) OR ((vitamins) AND (for) AND (hair)) OR ((vicam)) OR > > > ((renatabs)) OR ((fabb)) OR ((rena‐vite)) OR ((infuvite)) OR > > > ((cota‐b‐plex)) OR ((poly) AND (vit) AND (with) AND > > > (infant) AND (drop)) OR ((vitacirc‐b)) OR ((nephrocaps) AND > > > (qt)) OR ((l‐methyl‐b6‐b12)) OR ((bounty) AND (bear) > > > AND (vitamins)) OR ((folic) AND (acid/vitamin) AND b AND > > > (complex/vitamin) AND (c)) OR ((mega) AND (b)) OR ((vitamin) AND > > > (liquid)) OR ((tri‐vit) AND (drops)) OR ((vitamin) AND (a) AND > > > d AND (softgels)) OR ((apatate)) OR ((high) AND (potency) AND (b+c)) > > > OR ((t‐vites)) OR ((b‐plex)) OR ((combgen)) OR > > > ((vita‐respa)) OR ((folamin)) OR ((foltrate)) OR ((stress) AND b > > > AND (with) AND (c)) OR ((l‐methylfolate) AND (ca,) AND > > > (me‐cbl) AND (nac)) OR ((surbex)) OR ((triveen‐cf)) OR > > > ((renaphro)) OR ((one‐a‐day) AND (essentials)) OR > > > ((sunkist) AND (child) AND (chewable) AND (with) AND (c)) OR ((one) > > > AND (daily)) OR ((vesselvite)) OR ((b‐ject) AND (100)) OR > > > ((enfolast‐n)) OR ((folbee) AND (plus)) OR ((folastin)) OR > > > ((therobec)) OR ((theragenerix)) OR ((megaton)) OR ((tri‐vit)) OR > > > ((enfolast)) OR ((dialyvite) AND (rx)) OR ((renal) AND (caps)) OR > > > ((b‐plex) AND (plus)) OR ((tri‐vita) AND (drops)) OR > > > ((vi‐stress)) OR ((d‐400) AND (international) AND (units)) > > > OR ((tab‐a‐vite)) OR ((b) AND (complex)) OR > > > ((vol‐care) AND (rx)) OR ((folast)) OR ((protegra) AND (cardio)) > > > OR ((folic) AND (acid/cyanocobalamin/pyridoxine) AND (hydrochloride)) OR > > > ((vita) AND (drop)) OR ((vitamin) AND (a,) AND (d)) OR > > > ((rovin‐cf)) OR ((apetigen)) OR ((folbalin)) OR > > > ((key‐plex)) OR ((b‐scorbic)) OR ((surbex‐t)) OR > > > ((cardiotek)) OR ((multiple) AND (vitamins) AND (essentials)) OR > > > ((vitaplex)) OR ((morplex)) OR ((balanced) AND (b‐50)) OR > > > ((folplex)) OR ((glutofac)) OR ((cardiotek) AND (rx)) OR ((oncovite)) > > > OR ((surbex) AND (with) AND (c)) OR ((vi‐daylin) AND (drops)) OR > > > ((scotts) AND (emulsion)) OR ((vitamin) AND b AND (complex) AND > > > (with) AND (vitamin) AND (c) AND (b12)) OR ((cod) AND (liver) AND > > > (oil) AND (mint)) OR ((vitamin) AND b AND (complex) AND (with) AND > > > (b12)) OR ((lipoflavonoid)) OR ((neurpath‐b)) OR > > > ((b‐complex) AND (50)) OR ((foltabs) AND (800)) OR > > > ((therapeutic) AND (vitamins)) OR ((folbalin) AND (plus)) OR > > > ((allbee‐c) AND (800)) OR ((allbee‐c)) OR ((zycose)) OR > > > ((diatx)) OR ((theragran)) OR ((sesame) AND (st.) AND (vitamins) AND > > > (with) AND (extra) AND (c)) OR ((folgard) AND ((obsolete))) OR > > > ((nephrocaps)) OR ((multivitamin)) OR ((flintstones) AND > > > (multivitamins)) OR ((folgard) AND (rx)) OR ((vitamin) AND b AND > > > (complex) AND (100)) OR ((cefol)) OR ((super) AND b AND (complex) AND > > > (with) AND (c)) OR ((flintstones) AND (with) AND c AND > > > (multivitamins)) OR ((tl) AND (gard)) OR ((daily) AND (multiple) AND > > > (vitamins)) OR ((superplex‐t)) OR ((foleve)) OR ((thex) AND > > > (forte)) OR ((m.v.i.) AND (pediatric)) OR ((vigomar) AND (forte)) OR > > > ((super) AND (plenamins)) OR ((ivites) AND (rx)) OR ((multi) AND > > > (vits) AND (with) AND (beta) AND (carotene)) OR ((allantex)) OR > > > ((foleve) AND (plus)) OR ((b) AND (complex) AND (50)) OR > > > ((nephro‐vite) AND (rx)) OR ((vitamin) AND b AND (complex) AND > > > (t/r)) OR ((dayalets)) OR ((b‐complex)) OR ((cerefolinnac)) OR > > > ((niafol)) OR ((folbic)) OR ((super) AND (aytinal) AND (50) AND > > > (plus)) OR ((farbee) AND (with) AND (c)) OR ((garfield) AND > > > (vitamins) AND (with) AND (c)) OR ((b) AND (100) AND (complex)) OR > > > ((sigtab)) OR ((vimar)) OR ((folnate) AND (plus)) OR > > > ((daily‐vite) AND (men's) AND (formula)) OR ((cernevit)) OR > > > ((l‐methylfolate) AND (ca,) AND (p‐5‐p,) AND > > > (me‐cbl)) OR ((vi‐daylin) AND (chewable)) OR ((mtx) AND > > > (support)) OR ((may‐vita)) OR ((stress) AND (formula) AND (600)) > > > OR ((bee) AND (with) AND (c)) OR ((child) AND (circus)) OR > > > ((berocca)) OR ((stress) AND (formula) AND (caplets)) OR > > > ((thera‐plus)) OR ((daily) AND (vite)) OR ((multi‐delyn)) > > > OR ((m.v.c.) AND (sdv)) OR ((kenwood) AND (therapeutic)) OR > > > ((b‐complex) AND (sr)) OR ((folplex) AND (2.2)) OR ((vitamin) > > > AND (daily) AND (liquid)) OR ((bugs) AND (bunny) AND (with) AND > > > (extra) AND (c)) OR ((folnate)) OR ((b‐50) AND (complex)) OR > > > ((therapeutic) AND (b+c)) OR ((children's) AND (chewable) AND > > > (multivitamins)) OR ((theravite)) OR ((vitamin) AND (b‐50)) OR > > > ((high) AND (potency) AND b AND (complex) AND (with) AND (b12) AND > > > (c)) OR ((nufol)) OR ((m.v.i.) AND (adult)) OR > > > ((one‐a‐day) AND (men's) AND (health) AND (formula)) OR > > > ((b‐stress)) OR ((chewable) AND (vitamins)) OR > > > ((uni‐daily)) OR ((folgard) AND (rx) AND (2.2)) OR > > > ((vi‐daylin)) OR ((super) AND b AND (complex)) OR ((apetex)) OR > > > ((unicap) AND (jr.)) OR ((chewable‐vite)) OR ((multi‐day)) > > > OR ((b‐complex) AND (with) AND (b‐12)) OR > > > ((optilets‐500)) OR ((vitabee) AND (with) AND (c)) OR > > > ((nutrifac) AND (zx)) OR ((thera)) OR ((dexfol)) OR ((garfield) AND > > > (vitamins)) OR ((animal) AND (shape) AND (vitamins)) OR ((zymacap)) OR > > > ((one) AND (tab) AND (daily)) OR ((menopause) AND (relief) AND (with) > > > AND (lifenol)) OR ((stress) AND (formula)) OR ((cernevit‐12)) OR > > > ((vitamin) AND (b+c)) OR ((essential) AND (balance)) OR ((prostate) > > > AND (2.4)) OR ((metanx)) OR ((super) AND (b‐50)) OR ((infuvite) > > > AND (pediatric)) OR ((b‐50) AND (balanced)) OR ((land) AND > > > (before) AND (time) AND (children's) AND (with) AND (vitamin) AND > > > (c)) OR ((balanced) AND (b‐100) AND (time) AND (released) AND > > > (high) AND (potency) AND (caplets)) OR ((pyridoxine) AND > > > (cyanocobalamin) AND (folic) AND (acid)) OR ((folbic)))" > > > } > > > } > > > ], > > > "cutoff\_frequency" : 0.001 > > > } > > > }, > > > "sort": [{{@SORTQUERY}}], > > > "facets": {{@FACETQUERY}} > > > } > > > } > > > } > > > > > > Thanks, > > > Franklin > > > > > > -- > > > You received this message because you are subscribed to the Google > > > Groups "elasticsearch" group. > > > To unsubscribe from this group and stop receiving emails from it, send > > > an email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![simonw\_2](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/simonw_2/32/1130_2.png) [@simonw\_2](https://discuss.elastic.co/u/simonw_2)\ **Post date:** [May 29, 2013, 11:34am UTC](https://discuss.elastic.co/t/search-performance-issue/12036/11 "2013-05-29T11:34:20Z")
On Wednesday, May 29, 2013 8:33:26 AM UTC+2, Nicolas Labrot wrote: > Le mardi 28 mai 2013 15:04:46 UTC+2, simonw a écrit : > > > filters won't help here. Can you provide some info how slow the query is? > > I mean what is the usecase for this query, are you doing patent searches? I > > really can't see how can make this fast really. The only think I can think > > of is to change the structure entirely but without usecase hard to tell. > > Why filter won't help? I'm wondering if scoring for this type of query can > have a noticeable cost > > as you say the only thing you safe here is the score but this is not > making it massively faster simon > > simon > > > > On Tuesday, May 28, 2013 2:23:01 PM UTC+2, Nicolas Labrot wrote: > > > > > You shoud try to use filter instead of query. I don't think a score is > > > relevant with this type of query. > > > > > > On Tue, May 28, 2013 at 1:22 PM, Maria John Franklin \< > > > [mariajoh...@mycura.com](mailto:mariajoh...@mycura.com)\> wrote: > > > > > > > On Monday, May 20, 2013 6:22:34 PM UTC+8, Maria John Franklin wrote: > > > > > > > > > Hi Friends, > > > > > > > > > > ``` > > > > > Elastic search Performance is very slow when i add multiple OR > > > > > > > > > > ``` > > > > > > > > > > condition in query string..How to manage that one? > > > > > > > > > > # Example > > > > > > > > > > ( Discover OR the OR concepts OR and OR \*\*experiments OR that OR > > > > > define OR the OR \*\*fields OR of OR genetics OR molecular .....etc) > > > > > > > > > > Thanks, > > > > > Franklin > > > > > > > > Hi Simonw, > > > > This is my exact query..How to increase performance in this query? > > > > > > > > { > > > > "from": 0, > > > > "size": 10, > > > > "fields" :["test","test1","test2","\*\*test3","test4"], > > > > "query": { > > > > "bool": { > > > > "must": [ > > > > { > > > > "query\_string": { > > > > "query": "(((ascorbic) AND (acid,) AND (folic) AND (acid,) AND > > > > (niacin,) AND (thiamine,) AND (riboflavin,) AND (pyridoxine,) AND > > > > (cyanocobalamin,) AND (pantothenic) AND (acid,) AND (biotin)) OR > > > > ((nephrocaps)) OR ((multivitamin)) OR ((folbee)) OR ((vitamin) AND b > > > > AND (complex) AND (injectable)) OR ((therems)) OR ((rena‐vite) > > > > AND (rx)) OR ((unicap)) OR ((1000) AND (bc)) OR ((lipotriad)) OR > > > > ((vitamin) AND b AND (complex)) OR ((vitamin) AND (b‐100) AND > > > > (t/r)) OR ((bee‐comp) AND (with) AND (c)) OR ((folmor)) OR > > > > ((nephro‐vite)) OR ((balanced) AND (b‐150)) OR > > > > ((vita‐ret) AND (500)) OR ((neuroforte‐six)) OR > > > > ((poly‐vi‐sol) AND (drops)) OR ((tri‐vi‐sol)) OR > > > > ((super) AND (b‐100) AND (td)) OR ((balanced) AND (b‐100)) > > > > OR ((m.v.i.‐12)) OR ((foltx)) OR ((nephrolan) AND (rx)) OR > > > > ((cod) AND (liver) AND (oil)) OR ((baby) AND (vitamin) AND (drop)) OR > > > > ((equaline) AND (one) AND (daily) AND (essential)) OR ((lipogen)) OR > > > > ((triphro)) OR ((formula) AND (b)) OR ((poly‐vi‐sol)) OR > > > > ((vitamin) AND b AND (complex) AND (with) AND (c)) OR ((liponol)) OR > > > > ((hexavitamin)) OR ((cholinoid)) OR ((one‐a‐day) AND (50+)) > > > > OR ((high) AND b AND (complex)) OR ((cerefolin)) OR ((vitamin) AND > > > > (c,) AND (e,) AND (rose) AND (hips)) OR ((cholidase)) OR ((poly) AND > > > > (vit) AND (drops)) OR ((sunkist) AND (child) AND (chewable)) OR > > > > ((nephronex)) OR ((alz‐nac)) OR ((dialyvite) AND (800)) OR > > > > ((beminal‐500)) OR ((cardiotek‐rx)) OR ((poly‐vita) > > > > AND (drops)) OR ((reno) AND (caps)) OR ((stresstabs)) OR ((primaplex)) > > > > OR ((becomject‐100)) OR ((balanced) AND (b‐100) AND (high) > > > > AND (potency) AND (caplets)) OR ((super) AND (aytinal) AND (for) AND > > > > (active) AND (adults)) OR ((vitamin) AND b AND (complex) AND (with) > > > > AND (vitamin) AND (c)) OR ((vitamin) AND (b‐plex)) OR > > > > ((vi‐daylin) AND (adc)) OR ((neurodep)) OR ((unicap) AND > > > > (capsule)) OR ((fruity) AND (chew)) OR ((folcaps)) OR ((folbee) AND > > > > (ar)) OR ((biotin) AND (forte)) OR ((nephplex) AND (rx)) OR > > > > ((protegra)) OR ((poly‐vit) AND (chew)) OR ((vitamin) AND > > > > (b‐100)) OR ((vitamins) AND (for) AND (hair)) OR ((vicam)) OR > > > > ((renatabs)) OR ((fabb)) OR ((rena‐vite)) OR ((infuvite)) OR > > > > ((cota‐b‐plex)) OR ((poly) AND (vit) AND (with) AND > > > > (infant) AND (drop)) OR ((vitacirc‐b)) OR ((nephrocaps) AND > > > > (qt)) OR ((l‐methyl‐b6‐b12)) OR ((bounty) AND (bear) > > > > AND (vitamins)) OR ((folic) AND (acid/vitamin) AND b AND > > > > (complex/vitamin) AND (c)) OR ((mega) AND (b)) OR ((vitamin) AND > > > > (liquid)) OR ((tri‐vit) AND (drops)) OR ((vitamin) AND (a) AND > > > > d AND (softgels)) OR ((apatate)) OR ((high) AND (potency) AND (b+c)) > > > > OR ((t‐vites)) OR ((b‐plex)) OR ((combgen)) OR > > > > ((vita‐respa)) OR ((folamin)) OR ((foltrate)) OR ((stress) AND b > > > > AND (with) AND (c)) OR ((l‐methylfolate) AND (ca,) AND > > > > (me‐cbl) AND (nac)) OR ((surbex)) OR ((triveen‐cf)) OR > > > > ((renaphro)) OR ((one‐a‐day) AND (essentials)) OR > > > > ((sunkist) AND (child) AND (chewable) AND (with) AND (c)) OR ((one) > > > > AND (daily)) OR ((vesselvite)) OR ((b‐ject) AND (100)) OR > > > > ((enfolast‐n)) OR ((folbee) AND (plus)) OR ((folastin)) OR > > > > ((therobec)) OR ((theragenerix)) OR ((megaton)) OR ((tri‐vit)) OR > > > > ((enfolast)) OR ((dialyvite) AND (rx)) OR ((renal) AND (caps)) OR > > > > ((b‐plex) AND (plus)) OR ((tri‐vita) AND (drops)) OR > > > > ((vi‐stress)) OR ((d‐400) AND (international) AND (units)) > > > > OR ((tab‐a‐vite)) OR ((b) AND (complex)) OR > > > > ((vol‐care) AND (rx)) OR ((folast)) OR ((protegra) AND (cardio)) > > > > OR ((folic) AND (acid/cyanocobalamin/pyridoxine) AND (hydrochloride)) OR > > > > ((vita) AND (drop)) OR ((vitamin) AND (a,) AND (d)) OR > > > > ((rovin‐cf)) OR ((apetigen)) OR ((folbalin)) OR > > > > ((key‐plex)) OR ((b‐scorbic)) OR ((surbex‐t)) OR > > > > ((cardiotek)) OR ((multiple) AND (vitamins) AND (essentials)) OR > > > > ((vitaplex)) OR ((morplex)) OR ((balanced) AND (b‐50)) OR > > > > ((folplex)) OR ((glutofac)) OR ((cardiotek) AND (rx)) OR ((oncovite)) > > > > OR ((surbex) AND (with) AND (c)) OR ((vi‐daylin) AND (drops)) OR > > > > ((scotts) AND (emulsion)) OR ((vitamin) AND b AND (complex) AND > > > > (with) AND (vitamin) AND (c) AND (b12)) OR ((cod) AND (liver) AND > > > > (oil) AND (mint)) OR ((vitamin) AND b AND (complex) AND (with) AND > > > > (b12)) OR ((lipoflavonoid)) OR ((neurpath‐b)) OR > > > > ((b‐complex) AND (50)) OR ((foltabs) AND (800)) OR > > > > ((therapeutic) AND (vitamins)) OR ((folbalin) AND (plus)) OR > > > > ((allbee‐c) AND (800)) OR ((allbee‐c)) OR ((zycose)) OR > > > > ((diatx)) OR ((theragran)) OR ((sesame) AND (st.) AND (vitamins) AND > > > > (with) AND (extra) AND (c)) OR ((folgard) AND ((obsolete))) OR > > > > ((nephrocaps)) OR ((multivitamin)) OR ((flintstones) AND > > > > (multivitamins)) OR ((folgard) AND (rx)) OR ((vitamin) AND b AND > > > > (complex) AND (100)) OR ((cefol)) OR ((super) AND b AND (complex) AND > > > > (with) AND (c)) OR ((flintstones) AND (with) AND c AND > > > > (multivitamins)) OR ((tl) AND (gard)) OR ((daily) AND (multiple) AND > > > > (vitamins)) OR ((superplex‐t)) OR ((foleve)) OR ((thex) AND > > > > (forte)) OR ((m.v.i.) AND (pediatric)) OR ((vigomar) AND (forte)) OR > > > > ((super) AND (plenamins)) OR ((ivites) AND (rx)) OR ((multi) AND > > > > (vits) AND (with) AND (beta) AND (carotene)) OR ((allantex)) OR > > > > ((foleve) AND (plus)) OR ((b) AND (complex) AND (50)) OR > > > > ((nephro‐vite) AND (rx)) OR ((vitamin) AND b AND (complex) AND > > > > (t/r)) OR ((dayalets)) OR ((b‐complex)) OR ((cerefolinnac)) OR > > > > ((niafol)) OR ((folbic)) OR ((super) AND (aytinal) AND (50) AND > > > > (plus)) OR ((farbee) AND (with) AND (c)) OR ((garfield) AND > > > > (vitamins) AND (with) AND (c)) OR ((b) AND (100) AND (complex)) OR > > > > ((sigtab)) OR ((vimar)) OR ((folnate) AND (plus)) OR > > > > ((daily‐vite) AND (men's) AND (formula)) OR ((cernevit)) OR > > > > ((l‐methylfolate) AND (ca,) AND (p‐5‐p,) AND > > > > (me‐cbl)) OR ((vi‐daylin) AND (chewable)) OR ((mtx) AND > > > > (support)) OR ((may‐vita)) OR ((stress) AND (formula) AND (600)) > > > > OR ((bee) AND (with) AND (c)) OR ((child) AND (circus)) OR > > > > ((berocca)) OR ((stress) AND (formula) AND (caplets)) OR > > > > ((thera‐plus)) OR ((daily) AND (vite)) OR ((multi‐delyn)) > > > > OR ((m.v.c.) AND (sdv)) OR ((kenwood) AND (therapeutic)) OR > > > > ((b‐complex) AND (sr)) OR ((folplex) AND (2.2)) OR ((vitamin) > > > > AND (daily) AND (liquid)) OR ((bugs) AND (bunny) AND (with) AND > > > > (extra) AND (c)) OR ((folnate)) OR ((b‐50) AND (complex)) OR > > > > ((therapeutic) AND (b+c)) OR ((children's) AND (chewable) AND > > > > (multivitamins)) OR ((theravite)) OR ((vitamin) AND (b‐50)) OR > > > > ((high) AND (potency) AND b AND (complex) AND (with) AND (b12) AND > > > > (c)) OR ((nufol)) OR ((m.v.i.) AND (adult)) OR > > > > ((one‐a‐day) AND (men's) AND (health) AND (formula)) OR > > > > ((b‐stress)) OR ((chewable) AND (vitamins)) OR > > > > ((uni‐daily)) OR ((folgard) AND (rx) AND (2.2)) OR > > > > ((vi‐daylin)) OR ((super) AND b AND (complex)) OR ((apetex)) OR > > > > ((unicap) AND (jr.)) OR ((chewable‐vite)) OR ((multi‐day)) > > > > OR ((b‐complex) AND (with) AND (b‐12)) OR > > > > ((optilets‐500)) OR ((vitabee) AND (with) AND (c)) OR > > > > ((nutrifac) AND (zx)) OR ((thera)) OR ((dexfol)) OR ((garfield) AND > > > > (vitamins)) OR ((animal) AND (shape) AND (vitamins)) OR ((zymacap)) OR > > > > ((one) AND (tab) AND (daily)) OR ((menopause) AND (relief) AND (with) > > > > AND (lifenol)) OR ((stress) AND (formula)) OR ((cernevit‐12)) OR > > > > ((vitamin) AND (b+c)) OR ((essential) AND (balance)) OR ((prostate) > > > > AND (2.4)) OR ((metanx)) OR ((super) AND (b‐50)) OR ((infuvite) > > > > AND (pediatric)) OR ((b‐50) AND (balanced)) OR ((land) AND > > > > (before) AND (time) AND (children's) AND (with) AND (vitamin) AND > > > > (c)) OR ((balanced) AND (b‐100) AND (time) AND (released) AND > > > > (high) AND (potency) AND (caplets)) OR ((pyridoxine) AND > > > > (cyanocobalamin) AND (folic) AND (acid)) OR ((folbic)))" > > > > } > > > > } > > > > ], > > > > "cutoff\_frequency" : 0.001 > > > > } > > > > }, > > > > "sort": [{{@SORTQUERY}}], > > > > "facets": {{@FACETQUERY}} > > > > } > > > > } > > > > } > > > > > > > > Thanks, > > > > Franklin > > > > > > > > -- > > > > You received this message because you are subscribed to the Google > > > > Groups "elasticsearch" group. > > > > To unsubscribe from this group and stop receiving emails from it, send > > > > an email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Maria\_John\_Franklin](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@Maria\_John\_Franklin](https://discuss.elastic.co/u/Maria_John_Franklin)\ **Post date:** [May 30, 2013, 3:15am UTC](https://discuss.elastic.co/t/search-performance-issue/12036/12 "2013-05-30T03:15:03Z")
On Wednesday, May 29, 2013 7:34:20 PM UTC+8, simonw wrote: > On Wednesday, May 29, 2013 8:33:26 AM UTC+2, Nicolas Labrot wrote: > > > Le mardi 28 mai 2013 15:04:46 UTC+2, simonw a écrit : > > > > > filters won't help here. Can you provide some info how slow the query > > > is? I mean what is the usecase for this query, are you doing patent > > > searches? I really can't see how can make this fast really. The only think > > > I can think of is to change the structure entirely but without usecase hard > > > to tell. > > > > Why filter won't help? I'm wondering if scoring for this type of query > > can have a noticeable cost > > > > as you say the only thing you safe here is the score but this is not > > making it massively faster > > simon > > > > simon > > > > > > On Tuesday, May 28, 2013 2:23:01 PM UTC+2, Nicolas Labrot wrote: > > > > > > > You shoud try to use filter instead of query. I don't think a score is > > > > relevant with this type of query. > > > > > > > > On Tue, May 28, 2013 at 1:22 PM, Maria John Franklin \< > > > > [mariajoh...@mycura.com](mailto:mariajoh...@mycura.com)\> wrote: > > > > > > > > > On Monday, May 20, 2013 6:22:34 PM UTC+8, Maria John Franklin wrote: > > > > > > > > > > > Hi Friends, > > > > > > > > > > > > ``` > > > > > > Elastic search Performance is very slow when i add multiple OR > > > > > > > > > > > > ``` > > > > > > > > > > > > condition in query string..How to manage that one? > > > > > > > > > > > > # Example > > > > > > > > > > > > ( Discover OR the OR concepts OR and OR \*\*experiments OR that > > > > > > OR define OR the OR \*\*fields OR of OR genetics OR molecular > > > > > > .....etc) > > > > > > > > > > > > Thanks, > > > > > > Franklin > > > > > > > > > > Hi Simonw, > > > > > This is my exact query..How to increase performance in this query? > > > > > > > > > > { > > > > > "from": 0, > > > > > "size": 10, > > > > > "fields" :["test","test1","test2","\*\*test3","test4"], > > > > > "query": { > > > > > "bool": { > > > > > "must": [ > > > > > { > > > > > "query\_string": { > > > > > "query": "(((ascorbic) AND (acid,) AND (folic) AND (acid,) AND > > > > > (niacin,) AND (thiamine,) AND (riboflavin,) AND (pyridoxine,) AND > > > > > (cyanocobalamin,) AND (pantothenic) AND (acid,) AND (biotin)) OR > > > > > ((nephrocaps)) OR ((multivitamin)) OR ((folbee)) OR ((vitamin) AND b > > > > > AND (complex) AND (injectable)) OR ((therems)) OR ((rena‐vite) > > > > > AND (rx)) OR ((unicap)) OR ((1000) AND (bc)) OR ((lipotriad)) OR > > > > > ((vitamin) AND b AND (complex)) OR ((vitamin) AND (b‐100) AND > > > > > (t/r)) OR ((bee‐comp) AND (with) AND (c)) OR ((folmor)) OR > > > > > ((nephro‐vite)) OR ((balanced) AND (b‐150)) OR > > > > > ((vita‐ret) AND (500)) OR ((neuroforte‐six)) OR > > > > > ((poly‐vi‐sol) AND (drops)) OR ((tri‐vi‐sol)) OR > > > > > ((super) AND (b‐100) AND (td)) OR ((balanced) AND (b‐100)) > > > > > OR ((m.v.i.‐12)) OR ((foltx)) OR ((nephrolan) AND (rx)) OR > > > > > ((cod) AND (liver) AND (oil)) OR ((baby) AND (vitamin) AND (drop)) OR > > > > > ((equaline) AND (one) AND (daily) AND (essential)) OR ((lipogen)) OR > > > > > ((triphro)) OR ((formula) AND (b)) OR ((poly‐vi‐sol)) OR > > > > > ((vitamin) AND b AND (complex) AND (with) AND (c)) OR ((liponol)) OR > > > > > ((hexavitamin)) OR ((cholinoid)) OR ((one‐a‐day) AND (50+)) > > > > > OR ((high) AND b AND (complex)) OR ((cerefolin)) OR ((vitamin) AND > > > > > (c,) AND (e,) AND (rose) AND (hips)) OR ((cholidase)) OR ((poly) AND > > > > > (vit) AND (drops)) OR ((sunkist) AND (child) AND (chewable)) OR > > > > > ((nephronex)) OR ((alz‐nac)) OR ((dialyvite) AND (800)) OR > > > > > ((beminal‐500)) OR ((cardiotek‐rx)) OR ((poly‐vita) > > > > > AND (drops)) OR ((reno) AND (caps)) OR ((stresstabs)) OR ((primaplex)) > > > > > OR ((becomject‐100)) OR ((balanced) AND (b‐100) AND (high) > > > > > AND (potency) AND (caplets)) OR ((super) AND (aytinal) AND (for) AND > > > > > (active) AND (adults)) OR ((vitamin) AND b AND (complex) AND (with) > > > > > AND (vitamin) AND (c)) OR ((vitamin) AND (b‐plex)) OR > > > > > ((vi‐daylin) AND (adc)) OR ((neurodep)) OR ((unicap) AND > > > > > (capsule)) OR ((fruity) AND (chew)) OR ((folcaps)) OR ((folbee) AND > > > > > (ar)) OR ((biotin) AND (forte)) OR ((nephplex) AND (rx)) OR > > > > > ((protegra)) OR ((poly‐vit) AND (chew)) OR ((vitamin) AND > > > > > (b‐100)) OR ((vitamins) AND (for) AND (hair)) OR ((vicam)) OR > > > > > ((renatabs)) OR ((fabb)) OR ((rena‐vite)) OR ((infuvite)) OR > > > > > ((cota‐b‐plex)) OR ((poly) AND (vit) AND (with) AND > > > > > (infant) AND (drop)) OR ((vitacirc‐b)) OR ((nephrocaps) AND > > > > > (qt)) OR ((l‐methyl‐b6‐b12)) OR ((bounty) AND (bear) > > > > > AND (vitamins)) OR ((folic) AND (acid/vitamin) AND b AND > > > > > (complex/vitamin) AND (c)) OR ((mega) AND (b)) OR ((vitamin) AND > > > > > (liquid)) OR ((tri‐vit) AND (drops)) OR ((vitamin) AND (a) AND > > > > > d AND (softgels)) OR ((apatate)) OR ((high) AND (potency) AND (b+c)) > > > > > OR ((t‐vites)) OR ((b‐plex)) OR ((combgen)) OR > > > > > ((vita‐respa)) OR ((folamin)) OR ((foltrate)) OR ((stress) AND b > > > > > AND (with) AND (c)) OR ((l‐methylfolate) AND (ca,) AND > > > > > (me‐cbl) AND (nac)) OR ((surbex)) OR ((triveen‐cf)) OR > > > > > ((renaphro)) OR ((one‐a‐day) AND (essentials)) OR > > > > > ((sunkist) AND (child) AND (chewable) AND (with) AND (c)) OR ((one) > > > > > AND (daily)) OR ((vesselvite)) OR ((b‐ject) AND (100)) OR > > > > > ((enfolast‐n)) OR ((folbee) AND (plus)) OR ((folastin)) OR > > > > > ((therobec)) OR ((theragenerix)) OR ((megaton)) OR ((tri‐vit)) OR > > > > > ((enfolast)) OR ((dialyvite) AND (rx)) OR ((renal) AND (caps)) OR > > > > > ((b‐plex) AND (plus)) OR ((tri‐vita) AND (drops)) OR > > > > > ((vi‐stress)) OR ((d‐400) AND (international) AND (units)) > > > > > OR ((tab‐a‐vite)) OR ((b) AND (complex)) OR > > > > > ((vol‐care) AND (rx)) OR ((folast)) OR ((protegra) AND (cardio)) > > > > > OR ((folic) AND (acid/cyanocobalamin/pyridoxine) AND (hydrochloride)) OR > > > > > ((vita) AND (drop)) OR ((vitamin) AND (a,) AND (d)) OR > > > > > ((rovin‐cf)) OR ((apetigen)) OR ((folbalin)) OR > > > > > ((key‐plex)) OR ((b‐scorbic)) OR ((surbex‐t)) OR > > > > > ((cardiotek)) OR ((multiple) AND (vitamins) AND (essentials)) OR > > > > > ((vitaplex)) OR ((morplex)) OR ((balanced) AND (b‐50)) OR > > > > > ((folplex)) OR ((glutofac)) OR ((cardiotek) AND (rx)) OR ((oncovite)) > > > > > OR ((surbex) AND (with) AND (c)) OR ((vi‐daylin) AND (drops)) OR > > > > > ((scotts) AND (emulsion)) OR ((vitamin) AND b AND (complex) AND > > > > > (with) AND (vitamin) AND (c) AND (b12)) OR ((cod) AND (liver) AND > > > > > (oil) AND (mint)) OR ((vitamin) AND b AND (complex) AND (with) AND > > > > > (b12)) OR ((lipoflavonoid)) OR ((neurpath‐b)) OR > > > > > ((b‐complex) AND (50)) OR ((foltabs) AND (800)) OR > > > > > ((therapeutic) AND (vitamins)) OR ((folbalin) AND (plus)) OR > > > > > ((allbee‐c) AND (800)) OR ((allbee‐c)) OR ((zycose)) OR > > > > > ((diatx)) OR ((theragran)) OR ((sesame) AND (st.) AND (vitamins) AND > > > > > (with) AND (extra) AND (c)) OR ((folgard) AND ((obsolete))) OR > > > > > ((nephrocaps)) OR ((multivitamin)) OR ((flintstones) AND > > > > > (multivitamins)) OR ((folgard) AND (rx)) OR ((vitamin) AND b AND > > > > > (complex) AND (100)) OR ((cefol)) OR ((super) AND b AND (complex) AND > > > > > (with) AND (c)) OR ((flintstones) AND (with) AND c AND > > > > > (multivitamins)) OR ((tl) AND (gard)) OR ((daily) AND (multiple) AND > > > > > (vitamins)) OR ((superplex‐t)) OR ((foleve)) OR ((thex) AND > > > > > (forte)) OR ((m.v.i.) AND (pediatric)) OR ((vigomar) AND (forte)) OR > > > > > ((super) AND (plenamins)) OR ((ivites) AND (rx)) OR ((multi) AND > > > > > (vits) AND (with) AND (beta) AND (carotene)) OR ((allantex)) OR > > > > > ((foleve) AND (plus)) OR ((b) AND (complex) AND (50)) OR > > > > > ((nephro‐vite) AND (rx)) OR ((vitamin) AND b AND (complex) AND > > > > > (t/r)) OR ((dayalets)) OR ((b‐complex)) OR ((cerefolinnac)) OR > > > > > ((niafol)) OR ((folbic)) OR ((super) AND (aytinal) AND (50) AND > > > > > (plus)) OR ((farbee) AND (with) AND (c)) OR ((garfield) AND > > > > > (vitamins) AND (with) AND (c)) OR ((b) AND (100) AND (complex)) OR > > > > > ((sigtab)) OR ((vimar)) OR ((folnate) AND (plus)) OR > > > > > ((daily‐vite) AND (men's) AND (formula)) OR ((cernevit)) OR > > > > > ((l‐methylfolate) AND (ca,) AND (p‐5‐p,) AND > > > > > (me‐cbl)) OR ((vi‐daylin) AND (chewable)) OR ((mtx) AND > > > > > (support)) OR ((may‐vita)) OR ((stress) AND (formula) AND (600)) > > > > > OR ((bee) AND (with) AND (c)) OR ((child) AND (circus)) OR > > > > > ((berocca)) OR ((stress) AND (formula) AND (caplets)) OR > > > > > ((thera‐plus)) OR ((daily) AND (vite)) OR ((multi‐delyn)) > > > > > OR ((m.v.c.) AND (sdv)) OR ((kenwood) AND (therapeutic)) OR > > > > > ((b‐complex) AND (sr)) OR ((folplex) AND (2.2)) OR ((vitamin) > > > > > AND (daily) AND (liquid)) OR ((bugs) AND (bunny) AND (with) AND > > > > > (extra) AND (c)) OR ((folnate)) OR ((b‐50) AND (complex)) OR > > > > > ((therapeutic) AND (b+c)) OR ((children's) AND (chewable) AND > > > > > (multivitamins)) OR ((theravite)) OR ((vitamin) AND (b‐50)) OR > > > > > ((high) AND (potency) AND b AND (complex) AND (with) AND (b12) AND > > > > > (c)) OR ((nufol)) OR ((m.v.i.) AND (adult)) OR > > > > > ((one‐a‐day) AND (men's) AND (health) AND (formula)) OR > > > > > ((b‐stress)) OR ((chewable) AND (vitamins)) OR > > > > > ((uni‐daily)) OR ((folgard) AND (rx) AND (2.2)) OR > > > > > ((vi‐daylin)) OR ((super) AND b AND (complex)) OR ((apetex)) OR > > > > > ((unicap) AND (jr.)) OR ((chewable‐vite)) OR ((multi‐day)) > > > > > OR ((b‐complex) AND (with) AND (b‐12)) OR > > > > > ((optilets‐500)) OR ((vitabee) AND (with) AND (c)) OR > > > > > ((nutrifac) AND (zx)) OR ((thera)) OR ((dexfol)) OR ((garfield) AND > > > > > (vitamins)) OR ((animal) AND (shape) AND (vitamins)) OR ((zymacap)) OR > > > > > ((one) AND (tab) AND (daily)) OR ((menopause) AND (relief) AND (with) > > > > > AND (lifenol)) OR ((stress) AND (formula)) OR ((cernevit‐12)) OR > > > > > ((vitamin) AND (b+c)) OR ((essential) AND (balance)) OR ((prostate) > > > > > AND (2.4)) OR ((metanx)) OR ((super) AND (b‐50)) OR ((infuvite) > > > > > AND (pediatric)) OR ((b‐50) AND (balanced)) OR ((land) AND > > > > > (before) AND (time) AND (children's) AND (with) AND (vitamin) AND > > > > > (c)) OR ((balanced) AND (b‐100) AND (time) AND (released) AND > > > > > (high) AND (potency) AND (caplets)) OR ((pyridoxine) AND > > > > > (cyanocobalamin) AND (folic) AND (acid)) OR ((folbic)))" > > > > > } > > > > > } > > > > > ], > > > > > "cutoff\_frequency" : 0.001 > > > > > } > > > > > }, > > > > > "sort": [{{@SORTQUERY}}], > > > > > "facets": {{@FACETQUERY}} > > > > > } > > > > > } > > > > > } > > > > > > > > > > Thanks, > > > > > Franklin > > > > > > > > > > -- > > > > > You received this message because you are subscribed to the Google > > > > > Groups "elasticsearch" group. > > > > > To unsubscribe from this group and stop receiving emails from it, send > > > > > an email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ``` Hi simonw, then how can i handle this one? Any idea? Thanks, Franklin ``` > > > > > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 2:34am UTC](https://discuss.elastic.co/t/search-performance-issue/12036/13 "2017-07-06T02:34:00Z")