Doubt about MultiThreading RRS feed

  • Question

  • Hi All

    I need your advices about a problem that I met, in fact it's more a doubt concerning the benefit of the usage of multithreading on bulk load application.

    I explain myself :

    I spent a lot of time on testing multithreaded architecture with TPL, TreadPool, ... in the goal of improve the insert performance on CRM database (just service.create)
    I pass the details of the code, cuz im pretty sure that he is well formed. 

    My problem is that each multithreaded architecture tested dont gives an important performance improvement compare to a monothreaded application (simple loop + create) : approx. 40rec/sec to 50rec/sec !! 
    So I digged on internet, and finally I think that I understand something that I want to check with you :
    No matter the way to load my dataset and no matter the "speed call" of service.create, the requests themselves seems to be still processed sequentially by the platform !! 
    So the insert performances don't change a lot, because it seems that the network or something else limit the insert to 50rec/sec on my environnement... 
    I have also tried to call the program in two differents clients at the time, to check how the CRM server manage this... but the same result 50rec/sec max !!

    Is that true ? And if yes... Is there a way to improve insert performances ? How can I check in real time the server platform performance ?
    If you have some advices or idea, it weel be perfect :)

    PS : Unfortunatelly, I work on Rollup 10, so I cannot use ExecuteMultiple...

    Thanks a lot


    • Edited by Kyamit Thursday, December 12, 2013 10:45 AM
    Wednesday, December 11, 2013 4:58 PM

All replies