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.
1 Reply
No worries. I just found that
Ask AI has been added to the docs. I know how to improve my query and the operations thanks.
But if you have any recommendations I should keep in mind, please feel free to share them. It would mean a lot.