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.

Sign up for GitHub

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

Jump to bottom

Accounts By Id In v2 Slow for Low Volume Accounts #9176

Closed
jnels124 opened this issue Aug 28, 2024 · 0 comments · Fixed by #9225
Closed

Accounts By Id In v2 Slow for Low Volume Accounts #9176

jnels124 opened this issue Aug 28, 2024 · 0 comments · Fixed by #9225
Assignees
@jnels124
Labels
citus Area: Citus database Area: Database enhancement Type: New feature rest Area: REST API
Milestone
0.113.0

Comments

@jnels124
Copy link
Contributor

Problem

When finding transactions for a payer account id, the consensus_timestamp index is used instead of payer_account_id + consensus timestamp

Solution

Investigate and identify solution

Alternatives

No response
@jnels124 jnels124 added enhancement Type: New feature rest Area: REST API database Area: Database labels Aug 28, 2024
@jnels124 jnels124 added this to the 0.113.0 milestone Aug 28, 2024
@steven-sheehy steven-sheehy added the citus Area: Citus label Aug 30, 2024
@jnels124 jnels124 mentioned this issue Sep 2, 2024
Merged
2 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jnels124 jnels124

Labels
citus Area: Citus database Area: Database enhancement Type: New feature rest Area: REST API
Projects
Mirror Node
Status: ✅ Done
Milestone
0.113.0
Development

Successfully merging a pull request may close this issue.

Adjust transaction table indexes hashgraph/hedera-mirror-node
2 participants
@jnels124 @steven-sheehy