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> 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.
For more options, visit https://groups.google.com/groups/opt_out.
Hi Friends,
My search Fuctionality having two type.
- 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}}
}
}
}
- 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.
For more options, visit https://groups.google.com/groups/opt_out.