I have a problem with facets on nested documents.
Here is my code (PHP):
The populate() method creates the mapping and indexes documents.
The search method returns results.
My PHP code creates 5000 players and 100-200 balls per player.
The "and" filter is not really useful, but it allows to combine filters on
the root documents and the nested documents.
Currently, filter are only applied on nested documents.
There are 3 facets: 1 on the root documents, 2 on the nested documents.
The results and the first facet are ok, but the others facets aren't.
The "count" values are not what i expected: too high.
It counts the number of matching nested documents, instead of the number of
documents with matching nested documents.
Do you have a idea to solve my problem?
I found a solution, but it causes really bad performances...
I changed my mapping, and added "include_in_root" : true on nested documents
New mapping: https://gist.github.com/2929319
I also changed facets, the "nested" option is not
Facets counts are now ok,
but the execution time is awful: 8559ms!!!!!
And it takes a lot of memory.
The performance problem is bound to the "geo_distance" filter.
If I disable it, the execution time is ok.
But of course, this filter is essential for me
I tried to enable the cache on the "geo_distance" filter, but it changes
Can you help me?