Query execution is pretty fast.

But the result set looping and storing the result data into collections is taking longer time.


Please let me know is there any property that I can set to speed up the resultset looping.


The time consumption is more when the resultset is more than 1 lakh.


Any help on this appreciated.