DataConference45min
Database Connection Pool Sizing - Demystified!
This talk dispels the myth that bigger Oracle connection pools always boost performance. It explains, with practical formulas and Kingman’s law, why oversized pools can reduce efficiency. Attendees will learn to calculate optimal pool sizes based on workload and constraints, ensuring better performance, stability, and resource usage in backend applications.
Jasmin FluriSchaltstelle
talkDetail.whenAndWhere
Tuesday, March 24, 13:55-14:40
Room 7
talks.roomOccupancytalks.noOccupancyInfo
This talk addresses a common misconception in Oracle application development: that larger connection pools in the backend automatically lead to better performance.
While this belief is widespread, experienced DBAs understand that oversized connection pools can actually harm performance.
The presentation provides an introduction to connection pool sizing for backend developers of all seniority levels, explaining the reasons why excessively large pools negatively impact system throughput and resource efficiency.
A key part of the discussion focuses on mathematical principles behind connection pool behavior, including Kingman's law, which models queueing delays,
to illustrate how adding more connections can increase waiting times rather than reduce them.
The talk also covers the mathematical foundations for sizing connection pools optimally based on workload and resource constraints.
By the end of the session, attendees will be equipped with practical formulas and guidelines to calculate the appropriate size for their connection pools.
This knowledge will enable them to guide application teams towards resizing their pools in a way that maximizes performance, stability, and efficient resource use,
rather than simply increasing pool size in hopes of improving it.
While this belief is widespread, experienced DBAs understand that oversized connection pools can actually harm performance.
The presentation provides an introduction to connection pool sizing for backend developers of all seniority levels, explaining the reasons why excessively large pools negatively impact system throughput and resource efficiency.
A key part of the discussion focuses on mathematical principles behind connection pool behavior, including Kingman's law, which models queueing delays,
to illustrate how adding more connections can increase waiting times rather than reduce them.
The talk also covers the mathematical foundations for sizing connection pools optimally based on workload and resource constraints.
By the end of the session, attendees will be equipped with practical formulas and guidelines to calculate the appropriate size for their connection pools.
This knowledge will enable them to guide application teams towards resizing their pools in a way that maximizes performance, stability, and efficient resource use,
rather than simply increasing pool size in hopes of improving it.
Jasmin Fluri
Jasmin Fluri is a database and DevOps consultant at Schaltstelle GmbH, based in Bern, Switzerland.
She lectures on software engineering, databases, and data warehousing at the University of Applied Sciences North-western Switzerland.
As an Oracle ACE Pro and a recipient of the Redgate 100 recognition for influential voices in the database community, Jasmin aims to share good technical knowledge and help teams work well together in the database field.
Jasmin’s core goal is to empower development teams to deliver reliable, scalable, and maintainable solutions by implementing streamlined engineering processes and automation practices.
She specializes in setting up robust CI/CD pipelines, database infrastructure automation, and effective collaboration workflows.
She lectures on software engineering, databases, and data warehousing at the University of Applied Sciences North-western Switzerland.
As an Oracle ACE Pro and a recipient of the Redgate 100 recognition for influential voices in the database community, Jasmin aims to share good technical knowledge and help teams work well together in the database field.
Jasmin’s core goal is to empower development teams to deliver reliable, scalable, and maintainable solutions by implementing streamlined engineering processes and automation practices.
She specializes in setting up robust CI/CD pipelines, database infrastructure automation, and effective collaboration workflows.
talkDetail.shareFeedback
talkDetail.feedbackNotYetAvailable
talkDetail.feedbackAvailableAfterStart
talkDetail.signInRequired
talkDetail.signInToFeedbackDescription
occupancy.title
occupancy.votingNotYetAvailable
occupancy.votingAvailableBeforeStart
talkDetail.signInRequired
occupancy.signInToVoteDescription
comments.speakerNotEnabledComments