cube-js/cube
Voir sur GitHub@cubejs-client/core load / drilldown load method requires supports for pagination like `page`, `per_page`, to improve performance
Open
#1 434 ouverte le 24 nov. 2020
client:corehelp wanted
Métriques du dépôt
- Stars
- (19 563 stars)
- Métriques de merge PR
- (Merge moyen 5j 16h) (138 PRs mergées en 30 j)
Description
Is your feature request related to a problem? Please describe.
When using a drilldown load query, the number of records returned from db can be in the order or thousands or millions of records depending on the implementation and use-case. This can affect the performance of database server and can momentarily cause huge performance issues the database server.
Describe the solution you'd like
drilldown query should ideally support page, per_page, other than limit .
Describe alternatives you've considered No alternatives found as of now
Additional context
- records recieved in the order of thousands or millions can be pginated at front-end side, but the performance is affected very badly at the db side. This is a huge concern for the product team. Not able to go for deployment.
offsetis not enough to build a pagination ui, it gives a very bad UX