# ElasticsSearch performnce consideration

**URL:** <https://discuss.elastic.co/t/elasticssearch-performnce-consideration/277584>\
**Category:** Elasticsearch\
**Created:** [July 1, 2021, 6:08pm UTC](https://discuss.elastic.co/t/elasticssearch-performnce-consideration/277584 "2021-07-01T18:08:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![arctica82](https://avatars.discourse-cdn.com/v4/letter/a/c77e96/32.png) [@arctica82](https://discuss.elastic.co/u/arctica82)\
**Post date:** [July 1, 2021, 6:08pm UTC](https://discuss.elastic.co/t/elasticssearch-performnce-consideration/277584/1 "2021-07-01T18:08:22Z")

</div>

Hi Everyone,

I am new to ElaticSearch and we have some projects to move some our existing Databases from SQL SERVER to ElaticSearch. We are going to use ElasticSearch service provided in AWS. We are planing to use two below features. Does below features reduce the performance? Is there any performance consideration for below features.

1- Cross Cluster Search,in order to put old data into slower instance.(we can not use UltraWarm)  
2- Using union (union result set from different indexes in the same domain)

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [July 5, 2021, 2:23am UTC](https://discuss.elastic.co/t/elasticssearch-performnce-consideration/277584/2 "2021-07-05T02:23:09Z")

</div>

FYI the aws service is a fork of Elasticsearch and as such is not actual Elasticsearch. We are unable to provide support or recommendations if you use that service as they do not publish the changes they make to the product we develop and release.

> [@arctica82](#):
>
> 1- Cross Cluster Search,in order to put old data into slower instance.(we can not use UltraWarm)

This will not work with the aws service at all.

> [@arctica82](#):
>
> 2- Using union (union result set from different indexes in the same domain)

Elasticsearch SQL will not work with the aws service either.

---

<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:** [August 2, 2021, 2:23am UTC](https://discuss.elastic.co/t/elasticssearch-performnce-consideration/277584/3 "2021-08-02T02:23:12Z")

</div>

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