cube-js/cube
Auf GitHub ansehen@cubejs-client/core load / drilldown load method requires supports for pagination like `page`, `per_page`, to improve performance
Open
#1.434 geöffnet am 24. Nov. 2020
client:corehelp wanted
Repository-Metriken
- Stars
- (19.563 Stars)
- PR-Merge-Metriken
- (Durchschn. Merge 5T 16h) (138 gemergte PRs in 30 T)
Beschreibung
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