# Compare two large indexes with transform preview

**URL:** <https://discuss.elastic.co/t/compare-two-large-indexes-with-transform-preview/306149>\
**Category:** Elasticsearch\
**Tags:** painless\
**Created:** [June 1, 2022, 4:30pm UTC](https://discuss.elastic.co/t/compare-two-large-indexes-with-transform-preview/306149 "2022-06-01T16:30:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![szaby20](https://avatars.discourse-cdn.com/v4/letter/s/e5b9ba/32.png) [@szaby20](https://discuss.elastic.co/u/szaby20)\
**Post date:** [June 1, 2022, 4:30pm UTC](https://discuss.elastic.co/t/compare-two-large-indexes-with-transform-preview/306149/1 "2022-06-01T16:30:52Z")

</div>

Hi, I'm pretty new to Elastic so please bear with me. I'm trying to compare two large indexes (1.7 million and 400k) for regression testing purposes, which should contain exactly the same data once the larger index is filtered.  
As a PoC I've tried it with 2 small indexes using [**POST \_transform/\_preview**](https://www.elastic.co/guide/en/elasticsearch/reference/current/transform-painless-examples.html#painless-compare)  
This worked fine and I have an API that gets the results of this preview and prints a sort of summary. Now I am trying to replicate the same thing for the larger indexes but it seems like only the first 100 rows are compared/considered. I've been reading the documentation but I'm very confused about how I would go about achieving the same result for the large indexes.

Thanks in advance

---

<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:** [June 29, 2022, 4:31pm UTC](https://discuss.elastic.co/t/compare-two-large-indexes-with-transform-preview/306149/2 "2022-06-29T16:31:05Z")

</div>

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