yusiboyz/platform
1
0
Fork 0
Code Issues 4 Pull Requests Actions Packages Projects Releases Wiki Activity

Performance Hardening: Cache and De-risk Summary Endpoints #9

New Issue
Open
opened 2026-03-29 08:35:01 -05:00 by yusiboyz · 3 comments
yusiboyz commented 2026-03-29 08:35:01 -05:00
Owner
Copy Link

This issue covers performance and caching for dashboard and inventory/budget summaries.

Problems:

  • Inventory still performs repeated large scans/pagination for issue and count endpoints
  • Budget still fans out across accounts and transactions on-demand for summary and recent endpoints
  • Gateway dashboard still aggregates synchronously on request

Files:

  • services/inventory/server.js
  • services/budget/server.js
  • gateway/dashboard.py

Acceptance criteria:

  • Inventory counts and issue lists avoid repeated full-dataset scans
  • Budget summary endpoints use caching or precomputed summaries where appropriate
  • Dashboard aggregation has bounded latency under partial service slowdown
  • Performance expectations are documented and measured
This issue covers performance and caching for dashboard and inventory/budget summaries. Problems: - Inventory still performs repeated large scans/pagination for issue and count endpoints - Budget still fans out across accounts and transactions on-demand for summary and recent endpoints - Gateway dashboard still aggregates synchronously on request Files: - services/inventory/server.js - services/budget/server.js - gateway/dashboard.py Acceptance criteria: - Inventory counts and issue lists avoid repeated full-dataset scans - Budget summary endpoints use caching or precomputed summaries where appropriate - Dashboard aggregation has bounded latency under partial service slowdown - Performance expectations are documented and measured
yusiboyz added this to the Next milestone 2026-03-29 08:43:51 -05:00
yusiboyz commented 2026-03-29 10:13:12 -05:00
Author
Owner
Copy Link

Fixed in 4ecd233 — Budget summary cached 1min. Dashboard cached 30s per user (2.1s→40ms). Inventory health endpoint added.

**Fixed in 4ecd233** — Budget summary cached 1min. Dashboard cached 30s per user (2.1s→40ms). Inventory health endpoint added.
yusiboyz commented 2026-03-29 13:50:24 -05:00
Author
Owner
Copy Link

Completed in 9e13984 — Inventory /issues and /needs-review-count use server-side NocoDB WHERE filters (no full scans). Budget buildLookups cached 2min. Budget summary cached 1min. Dashboard cached 30s.

**Completed in 9e13984** — Inventory /issues and /needs-review-count use server-side NocoDB WHERE filters (no full scans). Budget buildLookups cached 2min. Budget summary cached 1min. Dashboard cached 30s.
yusiboyz commented 2026-03-29 15:17:41 -05:00
Author
Owner
Copy Link

Completed. Budget /transactions/recent cached 30s, /uncategorized-count cached 2min. Actual Budget per-account API constraint documented. All inventory full scans already eliminated. No remaining unmitigated hot paths.

**Completed.** Budget /transactions/recent cached 30s, /uncategorized-count cached 2min. Actual Budget per-account API constraint documented. All inventory full scans already eliminated. No remaining unmitigated hot paths.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
auth
critical
dependencies
high
immediate
medium
next
ops
performance
security
No Label
Milestone
No items
No Milestone Next
Projects
Clear projects
No project
Assignees
Clear assignees
yusiboyz
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: yusiboyz/platform#9
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?