Dashboards optimization, simultaneous SQL Query timed out

[zak-bykov]

Description

When a dashboard contains many tables with complex and large SQL queries, which, when executed individually, work flawlessly regardless of the size of the data range (1d or 30d) — begin to generate massive timeouts when executed simultaneously on the dashboard.

And I’m forced to split a large dashboard into smaller ones in order to reduce the number of simultaneously executed SQL queries and reduce the number of thrown timeout errors.

Can you please optimize simultaneous SQL queries execution on the dashboards?

Python, Logfire & OS Versions, related packages (not required)