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

Move elements count to its own procedure (blocks, txs and blobs) #572

Closed
PabloCastellano opened this issue Sep 17, 2024 · 0 comments · Fixed by #581
Closed

Move elements count to its own procedure (blocks, txs and blobs) #572

PabloCastellano opened this issue Sep 17, 2024 · 0 comments · Fixed by #581
Assignees

Comments

@PabloCastellano
Copy link
Member

PabloCastellano commented Sep 17, 2024

Counting elements in Postgres is costly, and we are currently counting the elements in /blocks, /blobs and /txs, which causes the table data to take some seconds to load.

The first step to tackle this unresponsiveness is to split the current api calls so that the count query is handled by a different API endpoint. This will allow the table to load faster and display the total count when the data is ready.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants