Hello!
I enjoyed reading this article. However, after further investigation, I believe this approach still doesn't provide true server-side pagination and may not effectively optimize WU (Workflow Unit) consumption.
For example, let's say I have 1,000 records and I want to display 10 records per page. If I navigate to the last page, using: :items until #1000
— this expression retrieves all items up to the 1,000th record, correct?
Then using: :items from #990
— would return the 990th to the 1,000th records, giving us 10 items.
The concern here is that by the time we apply :items from, Bubble has already loaded the first 1,000 items into memory. This means we're consuming WUs as if we fetched the entire dataset, even though we only need 10 records — which defeats the purpose of pagination and efficient data loading.
Let me know if I misunderstood any part of this. I'd love to hear your thoughts!
Thank you!