[GitHub] [incubator-superset] zuzana-vej commented on issue #10969: Is there any other way to accelerate dashboard?

[GitBox <gi...@apache.org>]

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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org