0
I would like a suggestion to improve the performance of these methods. They have taken too long to complete.
Please if the question is not very clear just say that I try to improve I will provide some images with the codes.
Good here is basically the loop I do some checks and transfer to the proper treatment
Here is the update I’m doing 
Here is method that instantiates the class calling dao so there is no blocking by some resource
I edited 23/09- Here I needed to limit the simultaneous tasks because I received Exception if I left it without paralleloption
Rodrigo, avoid placing images with the code, always write the code directly in the question. As for your problem, it might not be a problem with parallel tasks. You’ve run this routine normally, without
Task, to see if it takes too? You have already tested this query directly in SQL Server to see how it performs?– Pedro Gaspar
Hello all well thank you for answering, good yes I have tested this query in the bank about 2 seconds I have treated the possible errors, and as for the code yes there was an improvement in performance with the tasks but it is still slow.
– Rodrigo de Souza silva