Hello,
I have a urgent performance problem with my Vaadin 8 + Spring Boot application.
Every day when I start my application in the morning from the production server, it takes way to long to get some answer from the first database executions. When I do the same or other statements again the waiting time is normal.
I think its something about my connection to the database. After one night without connection to the database, it lost the connection and then it takes very long next time.
Before I used following Spring settings I couldnt get even any connection to the database again after one night:
spring.datasource.max-active=10
spring.datasource.initial-size=5
spring.datasource.max-idle=5
spring.datasource.min-idle=1
spring.datasource.test-while-idle=true
spring.datasource.test-on-borrow=true
spring.datasource.validation-query=SELECT 1
spring.datasource.time-between-eviction-runs-millis=5000
spring.datasource.min-evictable-idle-time-millis=60000
Hope you can help me with this.
Thanks!