Best practices for handling aggregated metrics and intermediate tables in Convex
❔Advice
We’re using Convex as our main database, and as our app grows, we’re starting to store a lot more metrics and analytics data (things like usage stats, event counts, and performance tracking).
Right now, we’re building intermediate tables with precomputed aggregations to keep queries fast — but it’s getting harder to maintain as the dataset expands.
I’m curious how other teams using Convex approach this:
Do you store and aggregate analytics data in Convex directly?
Or do you offload metrics to an external system?
Any best practices or patterns you’ve found helpful for managing analytics efficiently?
Would really appreciate hearing what’s worked for others!
Right now, we’re building intermediate tables with precomputed aggregations to keep queries fast — but it’s getting harder to maintain as the dataset expands.
I’m curious how other teams using Convex approach this:
Do you store and aggregate analytics data in Convex directly?
Or do you offload metrics to an external system?
Any best practices or patterns you’ve found helpful for managing analytics efficiently?
Would really appreciate hearing what’s worked for others!
