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


#1

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


#2

How are you fetching it?