[hu3]

Weird. In one of my Go explorations I wrote a naive trade algo backtracker which ingested 100,000 datapoints per second from SQLite on commodity hardware.

I'd expect something highly specialized such as GRPC server to perform better.

[jumpingmice]

Reading 100k rows per second from sqlite sounds WAY easier than serving 100k HTTP/2 queries in the same time.

[hu3]

True. But in my case the code also distributes these datapoints to multiple threads, computes technical indicators and simulates tradings while gathering statistics to finetunne parameters.

The only optimization I've done was to ditch maps wherever I could. They were dominating flamegraphs.

This is why I expected GRPC to perform better. But I agree it depends heavily on what's being done.

[tozeur]

How did Go perform compared to a language like python? I thought the db would be the bottleneck?

[hu3]

Python is awesome. It's fast as long you're mosty calling libraries. Not so fast if Python itself is doing most of the work.