Hello guys, I am allotted with a task to upload 17000 entries from excel to Queue, then process each transaction and set some values in the excel. I have used REFramework and created my solution. But the issue is that my bot (for testing purpose) completed 1000 entries in about 20 minutes. For the actual task of doing 17000 entries it is taking approximately 6 hours. How can I reduce this time to <1 hour.
Thanks.
Hi @Babar_Awan ,
Firstly use “bulk add queue item” in order to create queue items this will reduce your time which is taking place due to creating transaction one by one.
Read your excel at once in starting of process. Then perform updation in Datatable for each transaction and then finally write the excel.
I couldn’t say for sure the execution time get reduced to <1 hour but this way the process will be more efficient.
Please mark this as solution if this helps