query optimization & recommendation please
I’m using Convex for a project and need some advice on optimizing queries, especially for dashboard metrics. Currently, I have to query the entire dataset before performing operations, which could become inefficient as the dataset grows.
Could you recommend strategies or best practices for improving query performance, particularly when calculating dashboard metrics? Additionally, any insights on structuring schemas and defining indexes for large datasets would be appreciated.
Could you recommend strategies or best practices for improving query performance, particularly when calculating dashboard metrics? Additionally, any insights on structuring schemas and defining indexes for large datasets would be appreciated.
message.txt16.84KB
