Execute query activity is taking a long time

[Ajith209]

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.

[lrtetala (Lakshman Reddy)]

Hi @Ajith209

Please check on this

Loading or editing or deleting data using run query or run command is slow

@Lerato_Tsoela1 Everytime is it taking that much time? And generally from orchestrator…it first needs to login and then start the process so if the machine login takes some time then even that would increase over all time And generally first time as mentioned package downloads would be happening so generally it takes some time Apart from that can you check detailed logs like if the process itself is slow or any part of the process is going slow that way we can tackle specifically Cheers

Regards,

[Ajith209]

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.

[NiesonF]

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

Or use a different UiPath Package for running queries

[bkretzschmar (Bernd Kretzschmar)]

Or just use PowerAutomateDesktop, it takes 1% of the time.