superset-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From GitBox <...@apache.org>
Subject [GitHub] [incubator-superset] zuzana-vej commented on issue #10969: Is there any other way to accelerate dashboard?
Date Tue, 29 Sep 2020 03:08:43 GMT

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


Mime
View raw message