THDA commented on issue #2436: Slow query in SQL Lab URL: https://github.com/apache/incubator-superset/issues/2436#issuecomment-364883611 Confirmed here, this is dead slow and needs fixing, it even triggers a "this site does not respond" on ie. Turning on profiling, I see the following top offenders (displaying 3K rows here): Function | Count | Inclusive time | Exclusive time -----------|----------|----------------|---------------- appendChild|33?428|10?121,00|10?112,00 removeChild|9?973|7?047,00|6?749,00 innerHTML|57?173|5?857,00|5?856,00 getClientRects|247|3?467,00|3?467,00 n|6?342|1?650,00|1?071,00 There is definitely a need for server side pagination when supported by the underlying engine. Another way would be to postpone more things, for example only run those append/remove when the user clicks on the "next" button.
---------------------------------------------------------------- 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