I have two tables 1-Employee & 2- LogHistory
Employee has child as LogHistory
There are lots of entries against for one employee in LogHistory
Employe has properties employeeId, name, email and LogHistory list.
LogHistory has properties logindateTime, action, status, employeeId.
I want to query on condition with status to LogHistory and get Employee Object.
And want to use it in batch query because there are lots of entries in LogHistory so that can not fetch all data once otherwise it will increase latency.
Due to fetching all data in Query will cause slowness performance. May be in future table will have millions of data.
So please provide me any better solution WRT cloud data store so that i can get data in batch with single query or filter etc and also get all counts.
Current Scenario is:
In above case I am using JDO datastore with one to many relation & getting Employee Objects by LogHistory with status condition.
After Query:
LogHistory has Employee Object and only taking single Employee Object(By removing duplicate Employee).
But now I have much data so it is causing slowness and increasing latency.
Is there anyway or using low level API for the above scenario to get data by query so that i can also apply batch etc?