[GitHub] [druid] FrankChen021 commented on issue #11042: Druid Tasks UI breaks when there are so many tasks records

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

FrankChen021 commented on issue #11042:
URL: https://github.com/apache/druid/issues/11042#issuecomment-810137385


   
   I didn't know what exact error you encountered. Did it take too long for the servers to return the tasks to the UI ? or Did it take too long for the web-console to render UI while the servers response in very short time? And how many tasks are there ?
   
   And if it's the former one, maybe there's a way to improve it. Current task UI loads all tasks from router and does paging at client side. An optimization could be applied here, that is loading the tasks from server one page by one page by adding LIMIT/OFFSET clause to the sql. Since the default page size is 20, I think this would greatly reduce the data returned by servers and also reduce the time that the servers handle the query. 
   
   If this is the problem you met, you could do a test by adding LIMIT/OFFSET to the sql and post the query to the router to see if it saves time


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to 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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org