3 ms·
The process thing is irrelevant if you're using a decent database library with connection pooling. Mysql also performs/scales better when keeping connection cou
by ndriscoll 2y ago
The process thing is irrelevant if you're using a decent database library with connection pooling. Mysql also performs/scales better when keeping connection count proportional to the hardware. I'm personally not a fan of golang (scala has similar performance while being much easier to maintain IMO), but at least pooling is normal/relatively transparent there.
As with using many connections, a UUIDv4 PK is a case of "don't do that".
- sgarland 2y agoI’d say greatly reduced in magnitude, but not irrelevant. I’d also prefer to use middleware like PgBouncer or PgCat rather than relying on a library’s connection pooler, mostly because the latter IME has a habit of causing fun surprises from people not properly handling transactions. > “don’t do that” If I could get people to use RDBMS properly, I’d be both thrilled and potentially out of a job.