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 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 take too much time.Can you please help me


How are you fetching it?