Content
@
https://warpcast.com/~/channel/ponder-sh
0 reply
0 recast
0 reaction
Kevin
@typedarray.eth
Goal: By the end of 2025, even the largest Ponder app backfills will be fast enough to run in CI. Seconds or minutes, not hours or days. It should feel like a build or reload, not a "backfill".
3 replies
6 recasts
41 reactions
zerosnacks.eth
@zerosnacks
What are the tricks that make Ponder fast and what makes Subgraph slow? Never fetching more than strictly necessary? Efficient batching? Bloom filters?
1 reply
0 recast
1 reaction
Kevin
@typedarray.eth
Two main tricks 1) An architecture decision to decouple "sync" (download RPC data) from "indexing" (run user code and write to the database) 2) A in-memory cache for database rows to minimize blocking queries http://ithare.com/oltp-db-optimizations-102-100-coherent-app-level-cache-for-single-writing-db-connection/
0 reply
0 recast
4 reactions
