As we can't use native DBCP or any kind of java connection pool in AWS Lambda I have been using RDS proxy to connect MYSQL DB, But Still it takes 5 to 6 secs to make connection but I need the response from the lambda in <1 secs it there any way of keeping the connection warm. I'm using DriverManager.getConnection to get connection from RDS proxy
I have tired to connect proxy using
java.sql.DriverManager
Connection con = DriverManager.getConnection(("DB_Primary_IP"),("DB_Username"),("DB_Password"));