Time saving for execution

Help Studio
1

Hi all, i run multiple commands on 50 server & then gather the each server output & by filteration in that ,paste all data in excel file with (50 sheets )It takes around 5 min per server to perform .How can i reduce the exceution time (Used excel activities,if loop ,while ,for loop etc)

2

@priyanka_tambe

It’s difficult to say without knowing your usecase and your flow

but from the activities wise you can avoid for each loops if it is taking much time

Hope this may help you

Thanks

3

thanks

4

Hi @priyanka_tambe ,

Better to use Linq to filter data as this is fastest from other (Loop,DataTable.Select, Filter Activity).