# Parent data from oracle and child data from ES **URL:** \ **Category:** Elasticsearch\ **Created:** [July 9, 2014, 6:43pm UTC](https://discuss.elastic.co/t/parent-data-from-oracle-and-child-data-from-es/18560 "2014-07-09T18:43:35Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Srinath](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@Srinath](https://discuss.elastic.co/u/Srinath)\ **Post date:** [July 9, 2014, 6:43pm UTC](https://discuss.elastic.co/t/parent-data-from-oracle-and-child-data-from-es/18560/1 "2014-07-09T18:43:35Z")
hi , i am building simple application with one to many relationship type of loading . i read parent data from oracle and child data from ES (Since Es is bit fast ) and merge this into a single document. so now my problem is reading the data from ES in optimized way . Currently i am searching by match query QueryBuilders.matchQuery(" fieldName1", "0000000") . its taking 85 secs to retrieve 148371 documents . is there any better way to this . like grouping or indexing with fieldName1 . Java:- Is there any way to load full index into my heap one time and get the document from it because my index is small 70mb . is there any way to build parent child one to many relation between two separate index. . Please do the needful Thank You in Advance -- 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/9aaa1109-95c1-4b1a-ac62-2c31df354928%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/9aaa1109-95c1-4b1a-ac62-2c31df354928%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:16am UTC](https://discuss.elastic.co/t/parent-data-from-oracle-and-child-data-from-es/18560/2 "2017-07-06T01:16:56Z")