Hvala. Slowly getting closer to making it scale. It took 24 minutes to process the roll up data for @Jack for 3 months. Ha.
Discussion
😂
Are you running your own relay implementation?
Yep. NostrGraph.
Most people it loads ok as raw data up to around a month with 4+ graphs on the same page. I’ve created roll up tables and will add delta/incremental aggregation. Should be fine then.
Can’t make it public like this for all pubkeys. Maybe less granular with limits. Likely a payment.
That's expensive! How much are 24 CPU minutes on the instance you are using? Charge it in sats and people would still want it.
Ha. That’s just a once off calculation from beginning of time. I can easily do delta updates from there.
It’s a shared 4 vCPU 8GB. And it’s running other workloads.
For my pubkey it was seconds. @jack is an outlier for sure.
With roll up the query goes from 400ms to like 1.5ms with hourly resolution.
I can easily halve it too as a chunk of double handling.