zuzana-vej commented on issue #10969: URL: https://github.com/apache/incubator-superset/issues/10969#issuecomment-700398686
@appleyuchi the 3 major ways to optimize dashboard (excluding possibility with some issue with configurations which I wouldn't know about): 1. Engine optimization - can you use faster engine (as @nytai pointed out above) 2. Query optimization -- how complex is the SQL of your queries for the dashboard charts? Are you doing multiple joins, calculations, etc. did you limit how much data you query, optimizing the SQL query should have impact on the load time of your dashboard. 3. Dashboard complexity -- how complex is your dashboard meaning how many total charts do you have on the dashboard? These an initial load time to process metadata of the charts. We have seen in some cases for dashboards with large number of charts, and large amount of metadata (filter scopes, color settings etc) that just this time can go up to 7 seconds. By large number of charts I mean scale of 200 charts on a dashboard. There is `logs` table which you can go through to understand little more on where the time is coming from. It should have details on slice_id so you can see which charts are slowest, and the json column I believe should have lot more details. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
