Vlad,
I tried similar thing a while back. Of cause the query performance depends
on your ES configuration as well.
But I finally ended up giving up on parent/child, and flat the parent/child
document into nested object as the parent/child never gives me the
performance I need.
Chen
On Wednesday, March 18, 2015 at 11:53:28 PM UTC-7, Vladi Feigin wrote:
>
> Hello,
>
> I would like to ask for advice about our index that is built on the
> principle of Parent Child,
> Now a search word takes a very long time about 3 minutes.
> Below is the index structure.
>
> Our database (shown below the index schema) contains information about
> purchases and reviews in different stores.
> Parent contains meta data of purchase and the children contain comments
> regarding a purchase and names of goods (products).
> Important to note that the search will always be performed for only one
> shop (for a particular store_id). Although we have only one single index,
> no partitions so all stores are in this index
>
> At the moment the query to find the parent whose children have the word
> takes up to a few minutes .....
>
> Information on cluster and index:
> Number of documents 2.7 billion, the size of 360 gigs
> 9 shards, one replica (of 18)
> 6 physical nodes
>
> Your help is highly appreciated
>
> Vlad Feigin
>
> The index structure is :
>
>
> {
> "Purchase": {
> "mappings": {
> "_default_": {
> "dynamic": "false",
> "_all": {
> "enabled": false
> },
> "_ttl": {
> "enabled": true,
> "default": 34560000000
> },
> "_source": {
> "enabled": false
> },
> "properties": {
>
> }
> },
>
> "Parent": {
> "dynamic": "false",
> "_all": {
> "enabled": false
> },
> "_ttl": {
> "enabled": true,
> "default": 34560000000
> },
> "properties": {
> "store_id": {
> "type": "string",
> "index": "not_analyzed",
> "store": true
> },
> "endTime": {
> "type": "long",
> "store": true
> },
> "startTime": {
> "type": "long",
> "store": true
> },
> "purchaseId": {
> "type": "string",
> "index": "not_analyzed",
> "store": true
> }
> }
> },
> "comments": {
> "dynamic": "false",
> "_all": {
> "enabled": false
> },
> "_parent": {
> "type": "Parent"
> },
> "_routing": {
> "required": true
> },
> "_ttl": {
> "enabled": true,
> "default": 34560000000
> },
> "_source": {
> "enabled": false
> },
> "properties": {
> "text": {
> "type": "string"
> }
> }
> },
> "products": {
> "dynamic": "false",
> "_all": {
> "enabled": false
> },
> "_parent": {
> "type": "Parent"
> },
> "_routing": {
> "required": true
> },
> "_ttl": {
> "enabled": true,
> "default": 34560000000
> },
> "_source": {
> "enabled": false
> },
> "properties": {
> "name": {
> "type": "string"
> }
> }
> }
> }
> }
> }
>
> This message may contain confidential and/or privileged information.
> If you are not the addressee or authorized to receive this on behalf of
> the addressee you must not use, copy, disclose or take action based on this
> message or any information herein.
> If you have received this message in error, please advise the sender
> immediately by reply email and delete this message. Thank you.
>
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/2e6cd473-3b6f-448f-bbf3-0b37c6a6d320%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
