Hello,
I am struggling with the performance of Flexgrid object when an end-user opens it for the first time. To my mind, this performance is crucial for the acceptance of the new Board application within the end-user groups.
After that it is in cache and therefore faster. My Question regards the very first opening of each single Board user, so without considerations on browser's cache.
I hope some other users here have more experience and know a few tricks.
This is the setting of my screen:
- two objects (1 FlexGrid, 1 Label)
- screen select:
- 1 year
- entity active_members = "only active" =>results in selecting 1873 members of my tree base entity.
The FlexGrid shows 1.873 rows in developer mode:
und the layout is as follows:
The cube is structed by my tree base entity (Max item Number: 100.000) and by year.
There is nothing complex, the cube is shown at physical level.
When I log as a specific user (Thomas Enders), the user security profiles filters the data and it results in displaying 73 rows.
So I have no clue why the FlexGrid should be slow here. It loads in 1'25'' for this user showing 73 rows. All other users have the same experience regardless of their user profile.
Which are the general advice you know regarding Flexgrid performance?
- Base entities of the cubes shown should have a fixed (not infinite) Max item number
- Start small with a few blocks and grow step by step
- what else?
In my simple example, i have a very small data scope and the object is loading after more than 1 minute.
If i cannot improve on the layout, or cube's structure side, what about the server side? My Board instance is on-premises. I don't know if i can edit some server parameter, for example in server_config_v2.xml or in BoardEngineParams.xml or somewhere else…
Many thanks for your help and regards,
Arnaud Villemain
-
Board Version 15.1.0.2.629495