[Quality][Medium] Improve Horizon listener reconciliation: bounded performance and operational visibility

[1nonlypiece]

Problem

The current Horizon listener reconciliation implementation is a production-quality risk area: Ledger events can arrive late, duplicated, or out of order and must converge database projections without terminal-state regression.

This issue requires meaningful implementation and focused tests. Typo-only, documentation-only, formatting-only, dependency-only, and cosmetic changes do not satisfy the scope.

Objective

bound rendering, polling, network, and memory costs while making degraded behavior observable for the implementation anchored at src/config/horizonListener.ts; src/repositories/transactionRepository.ts.

Scope

• Establish the feature's explicit state, data, authorization, and failure invariants.
• Set explicit bounds for pagination, polling, chart points, upload sizes, and concurrent requests where applicable.
• Avoid redundant fetches and state updates during route changes, reconnects, or rapid user interaction.
• Expose actionable client telemetry or structured diagnostics for latency, failure, and recovery paths without leaking secrets.
• Keep the change focused on this feature and preserve unrelated public behavior.

Acceptance criteria

• The implementation defines and enforces the relevant invariants for normal and adversarial inputs.
• Set explicit bounds for pagination, polling, chart points, upload sizes, and concurrent requests where applicable.
• Avoid redundant fetches and state updates during route changes, reconnects, or rapid user interaction.
• Expose actionable client telemetry or structured diagnostics for latency, failure, and recovery paths without leaking secrets.
• Automated tests cover success, failure, boundary, retry, and permission behavior applicable to this feature.
• The PR includes validation commands, design tradeoffs, and any remaining limitations.
• The PR references this issue using Refs #<issue-number>.

Priority

Medium — determined by the potential impact on correctness, user funds or data, security, availability, and implementation depth.

Non-goals

• Do not make typo-only, documentation-only, formatting-only, dependency-only, or cosmetic changes.
• Do not remove tests merely to make CI pass.
• Do not introduce secrets, credentials, unsafe network defaults, or unrelated refactors.

Contributor application

Before starting, comment with relevant experience, a concise implementation approach, the main risks or tradeoffs, and an estimate for opening the first draft PR. Wait for maintainer assignment before coding.

Submission requirements

• Use PR title format: [#<issue-number>] <short summary>.
• Address every acceptance criterion in the PR description and implementation.
• Include focused automated tests and validation results.
• Explain any unavoidable limitations or pre-existing CI failures.
• Address maintainer review feedback before requesting final review.

Quality evaluation will consider scope adherence, implementation quality, test depth, security, correctness, review responsiveness, and follow-up stability.

[adelekevictor12]

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

Hello maintainer, i can fix this issue

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

[supremeproton01]

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

Hi maintainer, can i please be assigned to this

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

[drips-wave]

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

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