UI path is taking longer time to fetch data than SQL developer

Hi Team,

I am facing an issue where SQL developer is only taking 15 mins to get output for a query. it has about 148K worth of data. But UI path is taking 2+ hours for the same query. Can anyone please let me know if there is a faster way to do this in UI path.

Hi @Ajith209 ,

Process Your data in batches , which help the processing faster .

Lets say u have 100k data ,

process 25k as a batch and merge the final output .

Happy Automation