Issue of get few data from 1 million and it take two much time

try to fetch few data like two row from 1 million data and resultset.next take too much time. I find out date lie between two field which is start date and end date in one set. I set secondary column as Start Date and write down a lua for it Main Problem is client.queryAggregate doest n’t take take time but when get data in result set so resultset.next take too much time.Can you please help me

How are you fetching it?