Skip to content

Instantly share code, notes, and snippets.

@fed135

fed135/poolSize-calculator.md

Created October 8, 2020 14:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fed135/b4ab1abe68f0145df92bc8a405735efe to your computer and use it in GitHub Desktop.
Save fed135/b4ab1abe68f0145df92bc8a405735efe to your computer and use it in GitHub Desktop.
Download ZIP
Ideal database client pool size calculator
Raw
poolSize-calculator.md
  1. Identify total average [R]equests per second
  2. Identify average response [T]ime per request
  3. Calculate:

((R * T) / 1000) * 1.2

Ex:

((200 RPM * 200ms) / 1000) * 1.2 = 48 connections required

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment