Cursor Pagination

[fedeisas]

It would be awesome to have a Resource property that switches pagination mode from offset to cursor to ease the load on database servers with large tables.

Related

• Struggles working with Nova with large datasets #2345
• https://nova.laravel.com/docs/4.0/resources/#customizing-pagination

[crynobone]

This would mean that you no longer can sort the table by none unique attribute/field since cursor pagination explicitly required unique column. Definitely a huge limitation for existing applications and breaking changes.

[fedeisas]

Yes, I suspect that it could force sort with the resource's primary key or some timestamp.

My use case is a large events table (50m+ records) and running constant COUNTs on it seems wasteful. It loads really slowly.

Definitely a huge limitation for existing applications and breaking changes.

If the default pagination mode continues to be same maybe we can avoid it being a breaking change.

[crynobone]

Again, the cursor pagination limitation applied and would cause breaking change and Nova's field sortable() to not able to work any longer.

We not making these changes at the moment.

[BobbyBorisov]

Maaf, @crynobone what if this change is made with the notice that by using it the sortable() won't be able to work as intented? I think this is a fair tradeoff