Improve Database Query Performance

[Abd-Standard]

Description

Review slow queries and optimize database performance through indexing or query improvements.

Acceptance Criteria
Slow queries are identified.
Performance improves measurably.
Documentation is updated.

[Emprazzo01]

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

I have examined your specifications thoroughly and will implement a clean, compliant solution that aligns seamlessly with your acceptance criteria.

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

[king-aj-the-first]

@king-aj-the-first has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Helloo Repo Maintainer, I'd like to work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @king-aj-the-first to this issue.

[drips-wave]

Congratulations, @king-aj-the-first! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on July 30, 2026.

🧑‍💻 @king-aj-the-first: 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 🌊