is tanstack db an appropriate choice for a large paginated table?
I'm testing Tanstack db and feel like I'm going in circles on this issue. We run a larger Admin application that uses lots of tables (Tanstack table in fact). These tables have filters for the order status, who they are assigned to, the order type etc. This historically has been server-side paginated due to its size.
This is where my ignorance with Tanstack db is shining... if I use something like
Hopefully this question makes sense. For reference, I am using tRPC and Prisma.
This is where my ignorance with Tanstack db is shining... if I use something like
useLiveInfiniteQuery it works great, but all my searches/filters/etc (my whereeager it takes 15-20 seconds to load a 150mb table (not ideal either).Hopefully this question makes sense. For reference, I am using tRPC and Prisma.
