Execute query activity is taking a long time

Hi Team, I have a large volume of data around 178K but execute query is taking a long time to get the result. But when i run using SQL developer i am able to fetch it quickly. Please let us know if there are any alternatives to using execute query. Processing of batch wise is not an option also.

Hi @Ajith209

Please check on this


Hi, this is not helpful as i have built a test flow that just runs a hard coded query but it takes a long time in that also.

1.Run via python, save results in excel.
2.Read range from excel sheet.

Or use a different UiPath Package for running queries