Hello, I use a Metabase instance as a service. When a person uses it, it takes about 2 seconds to query the dataset. But when 45 people use it at the same time and make the same query, the longest response time reaches 60 seconds. This is too unacceptable for me. Where should I start to improve performance?
Jetty threads: 4/400 (35 idle, 0 queued) (197 total active threads) Queries in flight: 3
Hi @zsk
Which release or branch/commit?
How are you running (jar, docker, …)? And how many resources are available?
What is the metadata database?
Have you tried enabling cache? Admin > Settings > Cache.
Have you tried to figure out where the problem is?
User -> (network/internet) -> (proxy/load balancer) -> Metabase -> (network/internet) -> metadata -> (network/internet) -> database.