FilOzone / FilOzone/pdp-explorer

perf(subgraph): reduce store operations to speed up indexing

Open
#134 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
TypeScript
Stars
3
Forks
7
Avg merge
1d 4h
Merged PRs (30d)
4

Description

## Goal

Increase subgraph indexing speed (backfill and steady-state) by cutting store operations per event.

## Sub-issues

**Phase 1 — remove dead work (small diffs, no product impact):**
- [ ] #135 Remove dead SumTree maintenance from piece handlers
- [ ] #136 Stop materializing ProvingWindow entities
- [ ] #137 Remove dead tx-input ABI parsing in `handlePiecesAdded`
- [ ] #138 Cut per-event store round-trips (`loadInBlock`, redundant existence check)

**Phase 2 — structural (schema changes, client updates):**
- [ ] #139 Migrate weekly/monthly activity metrics to native timeseries + `@aggregation`
- [ ] #140 Slim `EventLog` / `Transaction` entities and drop unused counters

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the six linked sub-issues (#135–#140), especially the piece handlers and handlePiecesAdded named in Phase 1. Review the indexing paths and each sub-issue's scope before changing anything. Done means the selected store operations are removed or reduced while backfill and steady-state indexing remain correct and faster.

Written by the indexing model from the issue text.

Assessment

Tech stack
typescript
Domain
data, performance
Issue type
Refactor
Difficulty
5/5
Estimated time
Over a week
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.