# Manage database connection pool size in EHRBase

**Category:** [Platform](https://discourse.openehr.org/c/platform-implem/7)
**Created:** 2024-06-10 04:55 UTC
**Views:** 276
**Replies:** 5
**URL:** https://discourse.openehr.org/t/manage-database-connection-pool-size-in-ehrbase/5342

---

## Post #1 by @Dileep_V_S

Hi,
Are there any configuration options in EHRBase to mange the database connection pool size?

regards

---

## Post #2 by @birger.haarbrandt

Should be this one here:

![image|646x500](upload://tmfcgFQY4Nyr34NjJ1r8PyuQyAO.png)

For the environment variable it should work with SPRING_DATASOURCE_HIKARI_MAXIMUM_POOL_SIZE.

---

## Post #3 by @jake.smolka

Only regarding the env var binding: 
It would have to be `SPRING_DATASOURCE_HIKARI_MAXIMUMPOOLSIZE`.

(See: https://docs.spring.io/spring-boot/reference/features/external-config.html#features.external-config.typesafe-configuration-properties.relaxed-binding.environment-variables)

---

## Post #4 by @Dileep_V_S

Thanks,
I am using .env.local with docker compose. Do you know if this works in my case

SPRING_DATASOURCE_HIKARI_MAXIMUM_POOL_SIZE=50
SPRING_DATASOURCE_HIKARI_MINIMUM_IDLE=10

regards

---

## Post #5 by @birger.haarbrandt

If you adjust according to Jake's suggestion, I'm confident that it should work

---

## Post #6 by @Dileep_V_S

Thanks

Regards

---


**Canonical:** https://discourse.openehr.org/t/manage-database-connection-pool-size-in-ehrbase/5342
**Original content:** https://discourse.openehr.org/t/manage-database-connection-pool-size-in-ehrbase/5342