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

[Sandeepv68]

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

[vasilev-alex]

Hi @SandeepVattapparambil! Not quite sure what you mean by "bad UX", but the limit property is actually enough to build pagination. You can have a look at one of our examples

[hassankhan]

Hi @SandeepVattapparambil 👋

Did you get a chance to check the example linked by @vasilev-alex? 😀

[Sandeepv68]

hello @hassankhan , yes i did check the example provided by @vasilev-alex , however, the example shows a query created manually. In my case, the query is a drilldown query, i am not sure how I can pass a count measure in that.