To maximize the operational efficiency of Composer., you need to take into account several factors to appropriately size the Composer. server in your operating environment:
  • Concurrent user count. This is the most important parameter that increases the load on the system. Concurrent users represent only a portion of the total number of available users in an organization who may access the Composer. server at the same time. A single-node deployment can handle up to 100 concurrent users with acceptable performance. If you need more than 100 users, you should consider using several Composer. nodes.
  • Entity (users, data sources, visuals, dashboard, etc) count. The number of entities in the system doesn’t impact the performance of the system if you have up to 1000 instances of each entity type. If you want to support more than 1000 instances of each entity type you must allocate more resources than shown in the table below.
  • Data cardinality. The amount of data processed doesn’t affect the performance of Composer., because Composer. pushes the work for the queries down to your data stores and thus will rely on the performance of your data stores. However, if you have large data set and want to group the data by a high-cardinality field, you should increase the resource allocation for the query engine.
  • High availability (HA). If your Composer. environment is an HA environment, sizing requirements may double if each Composer. microservice is running on multiple instances.
See also System Requirements for information about Composer system requirements. The table below reviews the recommended sizing guidelines for a single-node Composer. server. Keep in mind that the specifications provided are suggested starting points and reflect only the minimum estimates. Sizing for performance is impacted by many other factors outside of the ones mentioned here, such as where Composer. resides, the types of data sources you are using, interactions between applications and data sources, and a variety of other factors. The following sizing guidelines reflect testing of a single-node Composer. server with up to 1000 concurrent users, 400 data sources, 500 dashboards, and 6000 visuals.
Concurrent UsersHardware RequirementsTime Opening Dashboard (12 Visuals)Composer WebQuery EngineConnectorPostgreSQL Metadata Store
Up to 5Memory: 8 GB
CPU: 8 core
Disk: 100 GB		17 secondsMemory: 2 GBMemory: 1 GBMemory: 512 MBMemory: 512 MB
Up to 20Memory: 8 GB
CPU: 8 core
Disk: 100 GB		19 secondsMemory: 2 GBMemory: 1 GBMemory: 512 MBMemory: 512 MB
Up to 100Memory: 16 GB
CPU: 16 core
Disk: 100 GB		26 secondsMemory: 4 GB

Configuration Settings:

spring.datasource.hikari.maximum-pool-size=50		Memory: 3 GBMemory: 1 GBMemory: 1 GB
Up to 1000Memory: 16 GB
CPU: 16 core
Disk: 100 GB		4 minutesMemory: 5 GB

Configuration Settings:

spring.datasource.hikari.maximum-pool-size=150
server.jetty.max-threads=1000
query.engine.service.maxConcurrentRequests=1000		Memory: 4 GB

Configuration Settings:

server.jetty.max-threads=1000		Memory: 1 GBMemory: 1 GB