# Performance About Parent-Child vs Duplicating Data

**URL:** <https://discuss.elastic.co/t/performance-about-parent-child-vs-duplicating-data/163888>\
**Category:** Elasticsearch\
**Created:** [January 11, 2019, 10:59am UTC](https://discuss.elastic.co/t/performance-about-parent-child-vs-duplicating-data/163888 "2019-01-11T10:59:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ismailcakir](https://avatars.discourse-cdn.com/v4/letter/i/dbc845/32.png) [@ismailcakir](https://discuss.elastic.co/u/ismailcakir)\
**Post date:** [January 11, 2019, 10:59am UTC](https://discuss.elastic.co/t/performance-about-parent-child-vs-duplicating-data/163888/1 "2019-01-11T10:59:49Z")

</div>

Hello Everyone,

I have two SQL table which are one to many relationship. Should i create parent-child relations or duplicate data in elasticsearch?

For example: Object1(Parent) has 100 records, Object2(child) has 1000 records.

-When creating parent-child relations, i have 1100 records in my index.  
-When duplicate object1 data in object2 i have 1000 records in my index(object1 will be stored in object2).

In my model not too much duplicate data will be available(max 6 record). I have wildcard queries my search query.

Is elasticsearch better than working parent-child relationship vs duplicating data?

Thanks for helps.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [January 11, 2019, 11:25am UTC](https://discuss.elastic.co/t/performance-about-parent-child-vs-duplicating-data/163888/2 "2019-01-11T11:25:47Z")

</div>

IMHO in most cases it's better to do join at index time, so I'd:

> duplicate object1 data in object2 i have 1000 records in my index(object1 will be stored in object2).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 8, 2019, 11:25am UTC](https://discuss.elastic.co/t/performance-about-parent-child-vs-duplicating-data/163888/3 "2019-02-08T11:25:58Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.