Performance

If multiple users are using the same dashboard , How could be the performance?

And how to increase performance if there is large data load and multiple users are loading into same module at same time?

 

 

Tagged:

Answers

  • Hi @PujithaB 

     

    When more users are using the same model, performance is worse than the case if less users are using the same model. Then the question becomes:

    1. How many total users are added to the model?

    2. What's the % of users who are concurrently using the same model?

    Please refer to https://community.anaplan.com/t5/Model-Concurrency-Testing/tkb-p/Customer-Performance-Testing-Database

     

    Regarding your question of "And how to increase performance if there is large data load and multiple users are loading into same module at same time?", i would suggest looking into 2 possibilities:

    1. Create a data hub. Please refer to https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866

    2. Split the 2 activities, eg schedule the large data load to happen during an offpeak period, so that when your business users are online, they won't be affected by this large data load.

     

    And as usual, please refer to the best practices in https://community.anaplan.com/t5/Best-Practices/tkb-p/communitykb to design an optimal solution.

     

    Thanks,

    LipChean

  • @PujithaB 

     

    As @LipChean_Soh already mentioned that more the robust design less the performance issues. Anaplan handles it quite well even if there are dozens of concurrent users on the same dashboard provided we'd followed the best practices in the model design.

    On Data Load - See if you can break the load in chunks - you can take it to 30, 40 chunks etc. and make sure that the load doesn't happen during peak time.

    Data Load from End users - Now this is something that is the bone of contention. Let me share my views: If there are end users who start loading their data at the same time then it might take sometime (here we are talking about 10 seconds to 20 seconds - based on the size and the number of users). If your processing time is higher than a minute or two then it might be worth to break the calculations link based on the input line item and stage/store end user driven numbers into standalone module and then pull the data for calculations later (schedule the job later during offpeak period) - this you have to take a buy in from end users that there will be a trade off between the performance and the real time 

     

    Hope that helps

    Misbah