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.
   
   Looks like this is done in superset/assets/visualizations/table.js.
   Digging through datatables.net-bs's API, I'll see if I can help 

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