Pagination Vs Caching And http.ts
❔Advice
Hi, Devs
When working with client hooks like "import { usePaginatedQuery } from "convex-helpers/react/cache"; " , you get caching and pagination out of the box,
which is not the case while using REST approach via http.ts so i thought about creating caching tables for mostly static data, by setting up some crons to do the heavy lifting [compute] by calling the existing functions with pre-defined pagination opts and save the results in the respective tables, so that my GET https endpoints just fetch data with doing any heavy compute, but this intern costs the pagination on http end points.
Has any come across such ?? and what is the best design to get the best through put and reduce latency.
Or do I have to choose over the other, for context, im working on some multi-vendor e-commerce platform, so i need to cache data like top ratings, sponsored items while also paginating
Thank you
When working with client hooks like "import { usePaginatedQuery } from "convex-helpers/react/cache"; " , you get caching and pagination out of the box,
which is not the case while using REST approach via http.ts so i thought about creating caching tables for mostly static data, by setting up some crons to do the heavy lifting [compute] by calling the existing functions with pre-defined pagination opts and save the results in the respective tables, so that my GET https endpoints just fetch data with doing any heavy compute, but this intern costs the pagination on http end points.
Has any come across such ?? and what is the best design to get the best through put and reduce latency.
Or do I have to choose over the other, for context, im working on some multi-vendor e-commerce platform, so i need to cache data like top ratings, sponsored items while also paginating
Thank you
