springdatasourcedruidmax-pool-prepared-statement-per-connection-size

The property "spring.datasource.druid.max-pool-prepared-statement-per-connection-size" is used to configure the maximum number of prepared statements that can be cached per connection in the Druid connection pool.

Prepared statements are SQL statements that are pre-compiled and stored in a cache for reuse. By reusing prepared statements, the database can optimize query execution and improve performance.

This property allows you to control the size of the prepared statement cache per connection. The default value is 20.

If you have a high number of concurrent connections to the database, increasing this value may improve performance by allowing more prepared statements to be cached per connection. However, it also increases memory usage, so you should carefully tune this value based on your application's requirements and available resources.

Here's an example of how to configure this property in the application.properties file:

spring.datasource.druid.max-pool-prepared-statement-per-connection-size=3