HikariCP connection pool configuration and tuning in AKS

[serena-tan]

Hi Community,

Really need your advise on the below.

Currently our spring boot running on Azure AKS is facing a lot of timed out issues due to utilization of all of the connections in our hikariCP pool. We are setting defaults - max 10 with 30s connectionTimeout.

The nature of this application requires fast updates (low latency with < 1s) and the transactions are usually very fast (below 1s) and TPS may go beyond 2000/s.

Would like to have some sensing whether is setting a max connection pool size 40 or 50, going to degrade the performance which leads to an increase in latency ?