[GitHub] mistercrunch commented on issue #2436: Slow query in SQL Lab

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

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


With regards,
Apache Git Services