Another way of doing proper pagination while fetching collections would be to do a separate query that only selects ids first and then subsequently do the original query just based on the ids. In Blaze-Persistence this is done automatically for you and you can even leverage keyset pagination through the same API. It's still joining the collections, but only for the elements on the actual page you are interested in.