Changed the Ora DB instance type to one having 2x fewer CPUs. That alone increased the db perf ~4x+

Eeeeeeeehm. 🤔

Wait, what? How?

@dmonkey @IntrusionCM

concurrency is a bitch.

Yes, we were perf-testing the system to the point we were seriously pushing AWS and ora limits. Tests were so harsh that AWS used [and still do] ask us to try out their services' upgrades to see how they perform.

We got to the point where the more powerful instance type we choose, the worse performance we get.

In perf engineering more coal != hotter fire

@netikras

Ah, ok. With perf testing it makes more sense, as this is usually the kind of stuff for nightmares.

E.g. thread / mutex contention and other stuff.

Lovely stuff.