cube-js/cube

@cubejs-client/core load / drilldown load method requires supports for pagination like `page`, `per_page`, to improve performance

Open

#1,434 建立於 2020年11月24日

在 GitHub 查看
 (3 留言) (1 反應) (0 負責人)Rust (19,563 star) (1,965 fork)batch import
client:corehelp wanted

描述

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

  1. 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.
  2. offset is not enough to build a pagination ui, it gives a very bad UX

貢獻者指南

技術棧
javascripttypescriptnodejs
領域
performancebackendanalytics
議題類型
feature
難度面向新貢獻者的預計實作難度，1 表示很小改動，5 表示專家級工作。
3
預計時間有經驗貢獻者完成調查、實作、測試並準備 pull request 的粗略時間範圍。
3-5 days
活動狀態議題目前的可參與程度：新鮮、活躍、陳舊、阻塞或等待維護者輸入。
stale
清晰度議題是否清楚說明預期改動、驗收標準和下一步。
clear
前置要求
Understanding of Cube.js client load methodFamiliarity with pagination patterns
新手友善度1-100 的估計分數，表示該議題對首次貢獻者的友善程度。
35
研究方向
Examine the existing 'load' method in '@cubejs client/core' (likely in 'packages/cubejs client core/src' directory). The issue requests adding 'page' and 'per page' parameters alongside existing 'limit'. Review any related discussions in comments; no linked PRs exist. Investigate how 'limit' is currently passed to the API and consider extending the query builder to support offset/pagination without degrading performance. Look for existing tests for the load method to understand expected behavior.