Can the following query be cached somehow? Our system calls it very frequently and the data is unlikely to change minute by minute
if you are using datasource, you can configure HikariCP or Apache DBCP2 connection pool and you can configure to cache the prepared statements. So make sure your queries should be prepared statements.
I’ll give that a go, thanks