H,
My requirement is very simple, I have a 1 million to less record in DB tables, Just to search with input criteria and insert fetched data in to another table and display it user screen. Does really ES fits here?
please suggest
Yes.
But we can't really say more unless you tell us more.