Question 2:- working with large datasets using UiPath's database activities While working with large datasets using UiPath's database activities, I’m experiencing memory issues and slow performance. I suspect that inefficient querying and resource manag

Help Studio
1

Question 2:-

working with large datasets using UiPath’s database activities

While working with large datasets using UiPath’s database activities, I’m experiencing memory issues and slow performance. I suspect that inefficient querying and resource management may be contributing factors. Are there best practices in UiPath for optimizing database operations and managing memory to handle large datasets more effectively?

2

@Bhagyshree_Khot

Welcome to the community

while fetching instead of getting whole data try to fetch usign where so that only required data coems in

cheers

3

Absolutely. Using stored procedures can streamline database interactions by precompiling SQL code, speeding up execution, and reducing server load. Effective resource management also plays a vital role. For example, limiting open connections, batching operations, and disposing of resources promptly prevent memory overload. Converting data into UiPath-friendly formats like DataTable further enhances processing efficiency, as it allows UiPath to handle the data within its environment, improving memory use and performance when working with large datasets

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.