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.

Reply to this note

Please Login to reply.

Discussion

I can easily halve it too as a chunk of double handling.