On Mon, Oct 18, 2004 at 10:38:23AM -0400, Paul Appleby wrote: > > >DBD::Oracle::dr::load_dbnames is only called by data_sources() > >so don't call data_sources() unless you really need to. > > I really do need to call data_sources() but the time it takes to > retrieve data, as shown above, using "Time::HiRes" is only > 0.0100140571594238 seconds. So that's not the issue.
dprofpp showed it to take approx the same time as login: > %Time ExclSec CumulS #Calls sec/call Csec/c Name > 21.6 0.090 0.090 1 0.0900 0.0900 DBD::Oracle::db::_login > 21.6 0.090 0.159 1 0.0899 0.1592 DBD::Oracle::dr::load_dbnames > 21.6 0.090 0.159 6 0.0149 0.0265 main::BEGIN Anyway, I think there's little you can do from DBI to make Oracle connections faster than you already have. Look to changes on the Oracle side - for which other mailing lists (such as oracle-l) are more suitable. Tim.