Efficient COUNT, SUM, MAX with the Aggregate Component
Stack convex.dev
This is what was read here when it was published. convex.dev no longer carries it in what it publishes now.
Listen to this summary
Convex omits built-in aggregates because full-table scans don’t scale; the video shows how @convex-dev/aggregate (B-Tree powered) enables fast pagination, ranking, per-user stats, and randomization with fully reactive queries. It also covers keeping aggregates in sync via triggers/custom functions, backfilling with migrations, and the trade-offs that hint at possible platform-level support.
More ways to use this
Open on another device
Scan to open this page. Your saved notes and account access are not included.