cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
Community Team Member
Community Team Member

Question

Is there any way to get the views to execute sequentially instead of simultaneously? How does the dashboard in Sisense execute the queries?

Answer

The Sisense client application does attempt to send out all queries (one per widget) at once, but in reality, they are not executed all at once. This is due to the inherent limitations of browsers and HTTP1.1 protocol - so in reality, there is actually a queue of queries to be sent to the server.

Then, on the ElastiCube server level, there's a configuration for a number of concurrent queries to be processed and a maximum number of threads per query, which can be accessed through the Sisense Server Console application (locally on the machine hosting your ElastiCubes). By default, when Sisense is installed this setting is dynamically configured according to the number of logical CPU cores available, in a ratio that works for most cases and rarely needs to be reconfigured. Please note that before changing this configuration you will need to consult with the Sisense Support team, and the change will cause the ElastiCube server to restart, resulting in a few moments of downtime.

Community_Admin_0-1634393744085.png

Was this article helpful?

Rate this article:
Version history
Last update:
‎10-16-2021 07:16 AM
Updated by:
Contributors