Replying to Avatar Blake

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.
Avatar
Blake 2y ago

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

Reply to this note

Please Login to reply.

Discussion

Avatar
Leo Wandersleb 2y ago

I wasn't suggesting that there was no room for improvement. My argument was more that even if it took as long as it took for Jack and even if you would not improve the performance, some people would pay for the CPU time. At Digitalocean they charge 7ct/h for 4vCPU/8GB. That's 3ct per query.

Avatar
Blake 2y ago

Thanks. I didn’t read it negatively. 🙂

It’s still a lot of work to productise, and I was on the fence putting the effort in - but I’m more and more seriously considering it. I see the value and people really like it.