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

Improve transaction count #594

Open
tdroxler opened this issue Dec 19, 2024 · 0 comments
Open

Improve transaction count #594

tdroxler opened this issue Dec 19, 2024 · 0 comments

Comments

@tdroxler
Copy link
Member

Our transaction count done in the cache is currently very naive and slow: Just count the number of txs in PG.

We know counting is slow in PG.

We could in the Finalizer service or somewhere else, count all new txs and add them to the previous count.

We should persist those data in db, so the load is done on the write-only instance, rather than every read-only.

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

No branches or pull requests

1 participant