The request was to look at the code You have written…
If You know how to fetch a page, You should be able to fetch given a page param. This should give You an offset and a limit.
And count will give You the total page number.
I am also doubtful about the use of Tasks to preload data when a cache could speed up db access.
Fetching data is already concurrent because You have a pool of workers in charge of Repo access.
