cube-js/cube
Vedi su GitHub@cubejs-client/core load / drilldown load method requires supports for pagination like `page`, `per_page`, to improve performance
Open
#1434 aperta il 24 nov 2020
client:corehelp wanted
Metriche repository
- Star
- (19.563 star)
- Metriche merge PR
- (Merge medio 5g 16h) (138 PR mergiate in 30 g)
Descrizione
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