docs: Create performance tuning guide for backend under high transaction load

[FaveTeamz]

Summary

The backend is expected to handle bursts of transaction submissions during popular issue drops. There is no documentation on how to tune the system (connection pool size, Redis cache TTL, Horizon RPC concurrency) for high load.

Problem

Operators facing a traffic spike have no reference guide for which knobs to turn. They must trial-and-error configuration changes during an active incident, increasing MTTR.

Acceptance Criteria

• Create docs/performance-tuning.md covering:
  • Database connection pool sizing (formula: connections = (core_count * 2) + effective_spindle_count)
  • Redis cache TTL recommendations for global cap vs org assignment queries
  • Horizon RPC concurrency limits and backpressure settings
  • ECS task CPU/memory right-sizing guidelines based on observed benchmark numbers
  • When to scale horizontally vs vertically
• Include a load testing checklist referencing the k6 test suite
• Add recommended CloudWatch alarms for saturation signals

[Muyideen-js]

@Muyideen-js has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hi, I can fix this

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

[OmniZlatoon]

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

Good day sir, Ready to deliver the task A.S.A.P. Gone through the issue and to be honest, i can work the task with the right tools at hand. please assign me maintainer . My eta is 5 hours

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

[code-draft-maker]

@code-draft-maker has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

hello maintainer i will like to work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @code-draft-maker to this issue.

[victor-134]

@victor-134 has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hi, I can implement this Asap Kindly assign to me

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

[p4uld4vid016-code]

@p4uld4vid016-code has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hello maintainer, i would like to work on this issue

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

[Daveeee-tech]

@Daveeee-tech has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hi maintainer I would love to solve this issue

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

[drips-wave]

Congratulations, @code-draft-maker! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on August 31, 2026.

🧑‍💻 @code-draft-maker: 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 🌊

[drips-wave]

This issue has been completed by @code-draft-maker as part of the Stellar Wave Program's 8th Wave 🥳

😎 @code-draft-maker: You earned 200 Points for completing this issue! After the current Wave ends, you'll be eligible for a percentage of the Wave's reward pool based on the percentage of total points you've earned. Learn more here. You can also Leave a review to share your experience working on this issue.

🧑‍💻 Repo maintainers: How'd the contributor do? Leave a review to share your experience working with them.