Implement database query optimization with composite indexes

[Smartdevs17]

Description

Database query performance degrades as data grows. Profile and optimize queries with composite indexes and query restructuring.

Acceptance Criteria

• Query profiling for top 20 slowest queries
• Composite indexes for common query patterns
• N+1 query detection and eager-loading
• Query time reduction (target: 80% for p95)
• EXPLAIN ANALYZE for all critical queries
• Slow query monitoring and alerting

Technical Scope

• backend/services/
• database schema/index files
• Edge: index maintenance overhead, write performance impact of new indexes

[yusufadeagbo]

@yusufadeagbo has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

I am happy to take this on and work on it.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @yusufadeagbo to this issue.

[driftsorbit]

@driftsorbit has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

I'd love to work on this issue please

ℹ️ Repo Maintainers: To accept this application, review their application or assign @driftsorbit to this issue.

[drips-wave]

Congratulations, @yusufadeagbo! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 2, 2026.

🧑‍💻 @yusufadeagbo: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊