I have a collection that fetches data from Supabase, but when there’s too much data, it starts to crash when fetching. I only fetch it if it hasn’t been fetched yet and on page load.
What I want is a paginator or a “load more” feature that retrieves only 10 items per page. When clicking “load more,” it should fetch the next 10 items (from 10 to 20, then 20 to 30, and so on). I want it to work without crashing, so whats the best choice? Ensuring the best possible performance.
For now using paginator, i’ve applied a filter inside the collection to fetch only 10 items, and in the paginator, I set it up to display the collection with that 10-item filter. However, what’s happening is:
The first page correctly displays 10 items.
The second page shows 20 items instead of just the next 10. So the paginator is working like a load more?
Should it really work like this?
) Backend pagination in Supabase is done at the collection level: 
