Open eeshabarua opened 7 months ago
We should use mongodb triggers instead of a stored procedure. The trigger should execute every time the the relevant collections in the production DB is updated.
Also, it would be nice if we could store these triggers in the repository instead of mongo's website so we could have nice version control and peer review, but that isn't a deal breaker.
Description
Currently, the donut chart and tree chart components run a tRPC procedure on every reload, which can lead to performance issues. Optimize the data using a MongoDB aggregation or stored procedure.
Learning Objectives
Todo
Useful Links