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!
Thank you for reaching out to us.
There are some recommendations which allow achieving better performance when working with Flexmonster Accelerator:
CacheManager.MemoryLimit(please see our example on GitHub)
We would like to mention that by default
CacheManager.MemoryLimit is set to
We hope this helps.
Please feel free to reach out if further questions arise.
Thank you. I have tried suggestion #3 and do see a performance increase. Looking into the other recommendations