OHi guys, I was hoping for some help. I'm
Hi guys, I was hoping for some help. I'm building an ERP using Convex and have roughly 50,000 products in the database.
I'm trying to figure out the best way to display them in a data table that shows the exact, up-to-date total count (so if I add a product, it updates instantly). I also need fast server-side filtering and search.
Everything I've tried with generators feels a bit off because I lose the ability to easily know the total number of items without scanning everything. Does anyone have a solid strategy for this?
I'm trying to figure out the best way to display them in a data table that shows the exact, up-to-date total count (so if I add a product, it updates instantly). I also need fast server-side filtering and search.
Everything I've tried with generators feels a bit off because I lose the ability to easily know the total number of items without scanning everything. Does anyone have a solid strategy for this?
