Re: [EXT] Issues connecting to an Amazon RDS instance: creating the database handle is taking a VERY long time

[email protected] (Mark Lawrence via dbi-users) Tue, 1 Apr 2025 10:53:25 +0000

Newsgroups	perl.dbi.users
Message-ID	<[email protected]>

On Mon Mar 31, 2025 at 11:20:11PM +0000, Johnson, Bruce E - (bjohnson) 
wrote:
>Sadly no. It’s still instantaneous on-prem but takes 61 seconds to get 
>the database handle with the ip address. (and DNS resolves just fine )

Second idea: you aren't explicitly specifying the connection port. 
There is evidence[1] of someone else observing a timeout related to 
1521, which I guess is the DBI default.

[1] https://dba.stackexchange.com/questions/60688/perl-dbi-takes-60-seconds-to-connect-to-an-oracle-database-every-single-time

What is your cloud database listening on? As the post suggests, setting 
DBI_TRACE will provide more food for investigation.

-- 
Mark Lawrence