News for hackers. Stuff that matters.

A comment on One Million Database Connections. Parent comment

Re:One Million Database Connections by vbezhenar on Tuesday November 01, 2022 @01:23PM (#33424278)
Introduce intermediate server which accepts multiple requests and groups them into single batch requests.

With enough trickery you can even implement it using postgres wire protocol, I guess, so it'll be transparent.

[ Parent | on HN ]
Re:One Million Database Connections by cbrewster on Tuesday November 01, 2022 @01:29PM (#33424387)
Now you need to batch your requests to your intermediate server
[ Parent | on HN ]
Re:One Million Database Connections by yamtaddle on Tuesday November 01, 2022 @01:31PM (#33424439)
No, you don't. You have one per 100 nodes or whatever. Not a single one for all nodes to talk to.
[ Parent | on HN ]
Re:One Million Database Connections by mjb on Tuesday November 01, 2022 @01:29PM (#33424389)
But why? Why have an additional component if your database can do it?
[ Parent | on HN ]
Re:One Million Database Connections by vbezhenar on Tuesday November 01, 2022 @03:38PM (#33426358)
twawaaay claimed that similar approach allowed him to improve throughput by factor of 50. Apparently database couldn't do it efficiently in that case.
[ Parent | on HN ]