Maintanance Consideration: DB Clean up

Help Activities
, ,
1

Hi Team,

I am new to DB query and update inside the process as a part of the bot using Uipath. So what all points we need to keep in mind for the bot performance during maintanance.

The bot keeps adding data , so is there any chance its going to impact the bot execution time going forward, when there will be increase in load in DB. Well we have a system where the DBA alerts about the space taken by DB and clean up data, but before that is it going to impact on the bot performance ?

Appreciate all your inputs.

Thanks!

2

Hi @kiranmili

Could you clarify? Is it about the performance of the process which is actively accessing a database that is being cleaned up, or is it about the process working with a database that is really big?

3

its about the performance of the process which is actively accessing a database that is being cleaned up occasionally.

4

@kiranmili,

In your case, the process performance is directly dependent on the database performance. After a certain point (where you have optimized your queries), you cannot alter the process to optimize its performance without optimizing the database speed.

To address this, you must consult with your DB admin to take dedicated measures outside of the UiPath processes. Adding indexes, query caching, choosing an appropriate storage engine are but a few aspects you might want to tackle. Of course, the solution depends entirely on your particular needs and environment.

5

Thanks Tetele!

1 Like
6

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