# Planning to move search functionality to elasticsearch

**URL:** <https://discuss.elastic.co/t/planning-to-move-search-functionality-to-elasticsearch/128495>\
**Category:** Elasticsearch\
**Created:** [April 18, 2018, 9:36am UTC](https://discuss.elastic.co/t/planning-to-move-search-functionality-to-elasticsearch/128495 "2018-04-18T09:36:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kartheek91](https://avatars.discourse-cdn.com/v4/letter/k/cc9497/32.png) [@kartheek91](https://discuss.elastic.co/u/kartheek91)\
**Post date:** [April 18, 2018, 9:36am UTC](https://discuss.elastic.co/t/planning-to-move-search-functionality-to-elasticsearch/128495/1 "2018-04-18T09:36:55Z")

</div>

Hi All,

we are building an application with c# web api ,sql server and Angular 5 .So we need to move search functionality to elasticsearch.Actually I have seen Nested objects and Parent child relationship.Which one is better.So the data is keeps on updating.

The sql query is having inner joins and left join, so my question is how to move to elasticsearch?

Thanks in advance,  
Kartheek Gummaluri

---

<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:** [April 18, 2018, 2:35pm UTC](https://discuss.elastic.co/t/planning-to-move-search-functionality-to-elasticsearch/128495/2 "2018-04-18T14:35:47Z")

</div>

It's preferable to do joins at index time and denormalize your data instead of doing complex things at search time.

Anyway, elasticsearch does not really support joins. But as you saw parent/child is providing that kind of join feature but you should use that after having explored all the other solutions.

---

<div class="post-metadata">

**Author:** ![kartheek91](https://avatars.discourse-cdn.com/v4/letter/k/cc9497/32.png) [@kartheek91](https://discuss.elastic.co/u/kartheek91)\
**Post date:** [April 19, 2018, 1:18pm UTC](https://discuss.elastic.co/t/planning-to-move-search-functionality-to-elasticsearch/128495/3 "2018-04-19T13:18:59Z")

</div>

Ok thanks David Pilato

---

<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:** [May 17, 2018, 1:19pm UTC](https://discuss.elastic.co/t/planning-to-move-search-functionality-to-elasticsearch/128495/4 "2018-05-17T13:19:01Z")

</div>

Closed on May 17, 2018, 1:19pm UTC

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