Get Free Trial

Suggestions to improve performance connecting via MS Analysis Services

Darius Studdard asked on October 13, 2020

Hi! I`m currently testing the trial version of your product as my company is considering purchasing it for use in our commercial software. Our stack is .NET MVC and I am utilizing your accelerator dll in order to connect to our OLAP cubes through MS Analysis Services. I`ve noticed that the performance is a bit slow at times when loading data, applying filters, etc. I was wondering if there is anything on the client or server side that I can implement to speed up performance. Our customers will need access to several data cubes and will need the ability to build their own reports so hard coding any specific subquery doesn`t seem like an option.  And suggestions would be much appreciated!

2 answers

Vera Didenko Vera Didenko Flexmonster October 15, 2020

Hello, Darius,
Thank you for reaching out to us.
There are some recommendations which allow achieving better performance when working with Flexmonster Accelerator:

  1. Please make sure that Flexmonster Accelerator and the MS Analysis Services instance are located on the same machine. That allows minimizing the time spent on data transfer.
  2. Please check the outbound speed of the server where Flexmonster Accelerator is located. If it is limited that could reduce performance.
  3. Increasing the cache size limit could also help to improve performance. When using Flexmonster Accelerator as a DLL, this can be configured via CacheManager.MemoryLimit (please see our example on GitHub)

    We would like to mention that by default CacheManager.MemoryLimit is set to 0 (unlimited).

We hope this helps. 
Please feel free to reach out if further questions arise. 
Kind regards, 

Darius Studdard October 20, 2020

Thank you.  I have tried suggestion #3 and do see a performance increase.  Looking into the other recommendations

Please login or Register to Submit Answer