We are doing embedding in Sisense since last year, have completed to on 3-4 projects but major concerns in all project is the speed of page load.
Sisense.js itself is 5MB, big enough to load, first we told that we have a lot of widgets and it is causing the delay, now we have reduced it to 6-7 max 9, but we are not happy with its performance in embedded solution.
As a developer my problem is the debuging, I applied all best practice as below without success:
1. Removed all external plugin
2. Removed all unrequited formatting, title widgets from Sisense dashboard
There are only 6 tables(5 Dimensions, 1 Fact) in cube, size is 4-5 MB total of cube, so there is no huge data.
Still loading a page with sisense widgets in MVC application is pain
So How to debug where the problem is??
My page in MVC is loading faster, then it stuck on the dashboard load method of Sisense, and then there is a long wait for the widgets even to show loader on the screen, really painful.
As per the recommendation server has 10 Virtual Processors, 17 GB RAM, and only 2-3 people accessing it.
I was told that sometimes cube has many to many that cause this issue, OK so I tried JAQL plugin to check which of my widget is having many to many relations, but all are one too many.
Now my question is how to debug it? Even SQL Server can return the same report much faster on same resources that we have on the server then when is the advantage of using Sisense.
Even after developing and spending so much time I am now thinking to replicate the same model on Power BI with same resource to check where the actual problem is, once done will update with all details here.
Till then if you have a solution or suggestion to improve performance in Sisense dashboards with Sisense.js embedding then please let me know.
Please sign in to leave a comment.