timifasubaa commented on issue #4588: [sqllab] How can we make large Superset queries load faster? URL: https://github.com/apache/incubator-superset/issues/4588#issuecomment-375827342 Some more ideas were shared at today's meeting. One was having a separate flow for downloading query results as CSV. Then for non csv, Always limiting the query before sending to the db ( this should help reduce Presto load). The question here is that when the query is eventually run on a slice, it still runs the full query. Or do we want to limit that too? Another potentially separate idea is to respond early and display results on the frontend when the db has the first 1000 rows ready. (This can be known from the stats object returned from polling). THen rendering the rest when the user clicks to see all. We will have to have an opinion on how superset should run queries and communiate that clearly in the interface so users, for example don't think the first 1K rows is all the results there is.
---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services
