Facets loading time

Elastic Stack Elasticsearch
1

Hi,
is there any way to improve facets loading time (into memory)?
I'm using field facets on a single string field and It's kind of a problem that the first query after indexing period is taking a long time (many unique users).

Has anyone ever faced this problem?
is there anyway to set the fields to load to cache automatically while indexing or warming up the index?

Thanks in advanced,

Oren

2

Hi,

did you try

?

Regards,
Lukas

On Mon, Jan 13, 2014 at 9:46 AM, oreno oreno@exelate.com wrote:

Hi,
is there any way to improve facets loading time (into memory)?
I'm using field facets on a single string field and It's kind of a problem
that the first query after indexing period is taking a long time (many
unique users).

Has anyone ever faced this problem?
is there anyway to set the fields to load to cache automatically while
indexing or warming up the index?

Thanks in advanced,

Oren

--
View this message in context:
http://elasticsearch-users.115913.n3.nabble.com/Facets-loading-time-tp4047460.html
Sent from the Elasticsearch Users mailing list archive at Nabble.com.

--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/1389602799729-4047460.post%40n3.nabble.com
.
For more options, visit 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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAO9cvUZCf_QJ4k5tAM7d0z7-98s3cOhM8hNr8uQ8GR_R0dU3Ow%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

3

Hey,

in addition/alternatively you could also look at warmers

--Alex

On Mon, Jan 13, 2014 at 1:11 PM, Lukáš Vlček lukas.vlcek@gmail.com wrote:

Hi,

did you try
Elasticsearch Platform — Find real-time answers at scale | Elastic
?

Regards,
Lukas

On Mon, Jan 13, 2014 at 9:46 AM, oreno oreno@exelate.com wrote:

Hi,
is there any way to improve facets loading time (into memory)?
I'm using field facets on a single string field and It's kind of a problem
that the first query after indexing period is taking a long time (many
unique users).

Has anyone ever faced this problem?
is there anyway to set the fields to load to cache automatically while
indexing or warming up the index?

Thanks in advanced,

Oren

--
View this message in context:
http://elasticsearch-users.115913.n3.nabble.com/Facets-loading-time-tp4047460.html
Sent from the Elasticsearch Users mailing list archive at Nabble.com.

--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/1389602799729-4047460.post%40n3.nabble.com
.
For more options, visit 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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/CAO9cvUZCf_QJ4k5tAM7d0z7-98s3cOhM8hNr8uQ8GR_R0dU3Ow%40mail.gmail.com
.

For more options, visit 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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAGCwEM-utXbFvM-T5jnrPqb-owwhzoC68-Ks8LpN-QF1kPgHWg%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

4

Hi Alexander,
yes warmers is exactly what I'm looking into right now.
Seems like a good solution, but I still have a problem there.
As shown below, I have a facet_filter with changing dates, so I'm having a hard time understanding what my warmer should look like if I want all the range possibilities to work fast.

I tried running the next warmer for loading both time and productCode fields, but I'm still not sure this is the best I can get here.

Any suggestions?

warmer:
{
"query" : {
"match_all" : {}
},
"facets": {
"tags": {
"terms": {
"fields": ["productCode", "time"]
},
"nested": "products"
}
}
}

query:
{
"query": {
"match_all": {}
},
"size": 0,
"facets": {
"tags": {
"terms": {
"field": "productCode",
"size": 230,
"regex": "GGG\d+",
"order": "term"
},
"nested": "products",
"facet_filter": {
"range": {
"products.time": {
"from": "2014-01-07",
"to": "2014-01-10",
"include_lower": true,
"include_upper": true
}
}
}
}
}
}