

Protofire | Token Utility Engineering
2K posts

@protofire
Proven solutions to scale your Web3 product: Safe multisig, staking, oracles, lending, stablecoins & more.










Our R&D unit, @DewPointLabs, just landed a contribution to the core of @blockscout. On every block import, Blockscout ran expensive cleanup queries even when nothing had changed. On a high-throughput chain with a transactions table north of 10 trillion rows, that consumed 194 of 200 database connections at once, with some queries running for 3 minutes. The fix: skip the work when there is nothing to clean up. Steady-state active connections dropped to around 40, and the query vanished from the database entirely. Merged upstream. Running explorers at scale is where you find these. PR: github.com/blockscout/blo…

















