Groups | Search | Server Info | Login | Register

Groups > perl.dbi.users > #3415

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

Show all headers | View raw

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

Back to perl.dbi.users | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Re: Issues connecting to an Amazon RDS instance: creating the database handle is taking a VERY long time dbi-users@perl.org (Mark Lawrence via dbi-users) - 2025-03-31 08:32 +0000
  Re: [EXT] Issues connecting to an Amazon RDS instance: creating the database handle is taking a VERY long time dbi-users@perl.org (Mark Lawrence via dbi-users) - 2025-04-01 10:53 +0000
    Re: [EXT] Issues connecting to an Amazon RDS instance: creating the database handle is taking a VERY long time dbi-users@perl.org (Mark Lawrence via dbi-users) - 2025-04-01 11:03 +0000

csiph-web