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

Performance: Convert before-time/after-time filters for transactions endpoint to rounds #1644

Merged

Conversation

gmalouf
Copy link
Contributor

@gmalouf gmalouf commented Jan 4, 2025

Summary

Convert before-time/after-time filters for transactions endpoint to rounds (major performance boost/avoid excessive query timeouts.

Test Plan

Existing tests should all pass, tested against Mainnet API queries outlined in issue #1518

…ounds (major performance boost/avoid excessive query timeouts.
@gmalouf gmalouf added Enhancement New feature or request performance labels Jan 4, 2025
@gmalouf gmalouf self-assigned this Jan 4, 2025
@gmalouf gmalouf requested a review from algorandskiy January 4, 2025 00:32
@gmalouf gmalouf merged commit f8b161f into algorand:main Jan 6, 2025
5 checks passed
@gmalouf gmalouf deleted the transaction-time-filter-optimization branch January 6, 2025 15:22
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Enhancement New feature or request performance
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Requests with after/before-time have unpredictable postgres query plans.
2 participants