[Backend] -- Add Database Connection Pooling Optimization

[Devsol-01]

Description

Optimize database connection pooling for better performance.

Tasks

• Analyze current pool settings
• Optimize pool size
• Add connection monitoring
• Implement connection retry
• Add pool metrics
• Document optimal settings

Acceptance Criteria

• Pool optimized
• Connections monitored
• Retry logic works
• Performance improved

---

[Timdavies155]

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

Hello, I’m interested in working on this task.

I have experience optimizing backend database layers in Node.js/NestJS systems, especially around connection pooling, performance tuning, and reliability under load.

For this task, I can:

• Analyze the current database connection pool configuration and identify bottlenecks
• Optimize pool size based on expected traffic patterns and workload characteristics
• Implement connection monitoring to track active, idle, and failed connections
• Add robust retry logic for transient database connection failures
• Expose pool metrics for observability and performance tracking
• Document recommended pool settings for production and staging environments
• Ensure changes improve stability and reduce latency under concurrent load

I focus on backend performance and reliability improvements, especially in database-heavy systems. I will ensure this optimization is safe, measurable, and leads to clear performance gains without introducing instability.

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

[Babigdk]

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

Hi 👋, Kindly assign this issue to me.

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

[TheBigWealth89]

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

i can Add this implementation unto your project please assign

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

[dee-john]

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

Hi, I'd like to work on this issue! because I am very conversant with solving problems like this!

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

[ussyalfaks]

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

I would like to work on this issue

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

[drips-wave]

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

🧑‍💻 @ussyalfaks: 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 🌊