[GitHub] [incubator-superset] bolkedebruin edited a comment on issue #7804: Server side pagination for charts (tables)

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

bolkedebruin edited a comment on issue #7804: Server side pagination for charts (tables)
URL: https://github.com/apache/incubator-superset/issues/7804#issuecomment-507576911
 
 
   To elaborate:
   
   We build an interactive dashboard for investigators. Those investigators are not able (knowledge wise) to create their own dashboards / queries for this particular investigation.
   
   So, we have two tables one with 25M transactions and another with 6M unique account numbers. A users needs to be able to filter the account number table to find a specific account number. Selecting this should then also filter the transaction table which can be a lot of transactions (easily > 70K)
   
   We have two options we have a filter box to select the account number this however seems to have a hard coded limit of much lower than the 6M we need. So this means missing account numbers when a user searches. Second option is to create another table which has a search box and can emit filter events. We can control the limit here, but 6M accounts will be sent to the browser as filtering happens clients side even if we use 'pagination'. If we set the limit to something the browser can handle the search will miss account numbers.
   
   On your comments. I think you are missing the mark, cause you seem to be talking about exports. We literally just need to be able to filter a large table on the front end without blowing up the browser and doing efficiently as multiple users will use the same tables.
   
   If needed we can have a video chat to show the issue. Fixing this would really help superset adoption (at least with us ;-) ) as it enables some really big dashboards.
   

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


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org