datagrid Feature: Indeterminate paginator

Hello, I have a huge tables (10s of millions of rows) which I use for searching in using datagrid. How ever there is an issue, COUNT for paginator is awfully slow because of how PostgreSQL works with counting.

I'd like to switch to indeterminate paginator where total count is not known and next pages is loaded based just on offset and limit and if no more rows are returned, it would be considered the end.

What do you think of such feature?

Currently there would be few issues, mainly datagrid does not allow custom paginators, and also DataModel is internal class which will call for count every time.

Oct 08 '21 07:10 juniwalk

It's same thing with mysql. Usually I just extended DataSource and override getCount function there to either provide my own query for count or to just cache it for some time... This however feels like much better solution

Nov 03 '21 15:11 dakorpar

I like that idea. Unfortunately no idea how to solved it. It will possible breaks the API. Maybe for next major v7.

Mar 11 '22 19:03 f3l1x