[Backend] Optimize Dashboard Aggregation Queries

[Abd-Standard]

Description

Reduce response times for dashboard statistics under heavy load.

Acceptance Criteria
Average query latency decreases.
Existing metrics remain accurate.
Performance benchmarks are updated.

[Babigdk]

Proposal: Dashboard Performance Optimization

I can work on improving dashboard statistics query performance under load.

Work:

• Optimize slow/expensive aggregation queries
• Add caching layer for frequently requested stats
• Reduce redundant DB calls in dashboard endpoints
• Introduce indexed query paths for high-traffic metrics
• Validate metric accuracy after optimization

Deliverables:

• Faster dashboard statistics responses under load
• Verified metric correctness
• Updated performance benchmarks showing improvement

Goal:
Lower average latency while maintaining accurate real-time dashboard data.

[dolaoluwa574-source]

I’m excited to contribute to impactful software improvements. My experience includes backend engineering, object-oriented programming, API development, Git collaboration, and building scalable, maintainable applications.

[DavisVT]

i'm a developer well fit for implementing this task
Kindly assign them to me

[grantfox-oss]

🦊 GrantFox — @DavisVT has been assigned to this issue as part of the Official Campaign campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #99)
2. Your PR will be reviewed by the Core-Foundry maintainers

Good luck! Track your progress on GrantFox.

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox as part of the Official Campaign campaign!

@DavisVT's PR #161 was approved and merged by @Abd-Standard.

🏆 @DavisVT: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (258 total points). Track your full progress on GrantFox.

👏 Great work, @DavisVT! Keep contributing to Core-Foundry.