Optimize Database Queries for Dashboard Statistics

[Abd-Standard]

Description
Review dashboard queries and reduce unnecessary database calls to improve loading performance.

Acceptance Criteria
Reduce query count.
Improve response time.
Preserve existing functionality.

[success-OG]

Hi Repo Maintainer,

I would like to work on this issue.

I have experience optimizing database queries and improving backend performance, and I’m comfortable identifying inefficient queries, reducing redundant calls, and ensuring response times are improved without affecting existing functionality.

I can analyze the current dashboard queries, optimize them, and validate performance improvements with proper testing.

Could you please assign this issue to me?

Thank you!

[grantfox-oss]

🦊 GrantFox — @success-OG has been assigned to this issue as part of the Official Campaign | FWC26 campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #78)
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 | FWC26 campaign!

@success-OG's PR #122 was approved and merged by @Abd-Standard.

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

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