Parent data from oracle and child data from ES

(Srinath) #1

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 .
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
To view this discussion on the web visit
For more options, visit

(system) #2