mistercrunch commented on issue #2436: Slow query in SQL Lab
URL: 
https://github.com/apache/incubator-superset/issues/2436#issuecomment-365090962
 
 
   @THDA are sounds like you're looking at the Table component in the "explore 
view" (not in SQL Lab). For the "explore view" we should use 
`react-virtualized` (as in SQL Lab).
   
   About SQL Lab, there are a few reasons why a CLI will beat Superset. In 
non-async mode, the CLI may run a `fetchmany` as opposed to `fetchall` and can 
start showing rows before the query is done executing. In async mode, there are 
much more things going on. The whole query gets executed, returned, cached in 
the results backend, and only then, once the client polls sees that the data is 
ready, the server will fetch the data from the results backend and return it to 
the client. Those delay become worse as the size of the dataset grows.

----------------------------------------------------------------
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

Reply via email to