Pagy is counting over my warehouse table and is taking too long

[titanve]

Hello,

I'm using pagy to paginate results from a warehouse table that has millions of records and the query to retrieve the records is fast but the count (I guess to get the total number of items) is taking too long, is there any way to improve this? maybe a configuration?

FYI: we are using arel also.

Thanks

[benkoshy]

Do you need a full nav bar? If not: https://ddnexus.github.io/pagy/docs/api/countless/ - this doesn't use the count query BUT you won't be able to jump to page 88 etc. because pagy will not know if such a page exists.

Or the other way is cursor based pagination: https://github.com/Uysim/pagy-cursor (I haven't used this library though).

[titanve]

Hi @benkoshy ,

you pasted the same link for pagy countless for your cursor based pagination suggestion, I believe it is another website, right?

Thanks!

[benkoshy]

fixed: https://github.com/Uysim/pagy-cursor