[GitHub] vylc opened a new issue #6681: [SQL Lab] Reduce number of queries needed to create a chart

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

vylc opened a new issue #6681: [SQL Lab] Reduce number of queries needed to create a chart
URL: https://github.com/apache/incubator-superset/issues/6681
 
 
   The number of query executions needed to get from SQL->Dashboard is inefficient. Stresses databases (more redundant query executions), slows down data analysis (waiting for queries to complete)
   
   Typical workflow to create a chart
   1st SQL run --> SQL Lab to execute query and get result sets
   2nd SQL run --> Clicking Explore, which instantiates the query as a datasource off of the result set
   3rd and more SQL runs --> Changing viz type (because user lands on a count of # of rows upon clicking Explore) and subsequent changes on the datasource all require re-execution
   
   Proposal: 
   (1) temporarily cache result sets for SQL queries run on a tab? Can be quickly discarded based on last query run on a tab. Persist as long as tab remains open or something reasonable like 24 hours?
   (2) If user click on Explore, persist result set in cache, such that subsequent actions don't require re-execution
   
   Open to other suggestions which solve the problem of too many SQL re-executions in order to explore/chart a result set which remains static.
   
   
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
   - [ ] I have reproduced the issue with at least the latest released version of superset.
   - [ ] I have checked the issue tracker for the same issue and I haven't found one similar.
   
   
   ### Superset version
   
   
   ### Expected results
   
   
   ### Actual results
   
   
   ### Steps to reproduce
   
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on 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


With regards,
Apache Git Services

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