Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cache list transactions #8000

Closed
steven-sheehy opened this issue Apr 1, 2024 · 0 comments · Fixed by #8187
Closed

Cache list transactions #8000

steven-sheehy opened this issue Apr 1, 2024 · 0 comments · Fixed by #8187
Assignees
Labels
enhancement Type: New feature performance rest Area: REST API
Milestone

Comments

@steven-sheehy
Copy link
Member

steven-sheehy commented Apr 1, 2024

Problem

The list transactions endpoint is the most heavily used endpoint and is also one of the slowest queries. /api/v1/accounts/{id} has similar problems.

Solution

For both /api/v1/transactions and /api/v1/accounts/{id}:

  • Query Redis by list of transaction timestamps and get JSON transaction output
  • Update Redis on cache miss

Alternatives

No response

@steven-sheehy steven-sheehy added enhancement Type: New feature performance rest Area: REST API labels Apr 1, 2024
@steven-sheehy steven-sheehy added this to the 0.103.0 milestone Apr 1, 2024
@steven-sheehy steven-sheehy self-assigned this Apr 11, 2024
@steven-sheehy steven-sheehy modified the milestones: 0.103.0, 0.104.0 Apr 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement Type: New feature performance rest Area: REST API
Projects
Status: Done
Development

Successfully merging a pull request may close this issue.

1 participant