Re: Oracle8 slow connect times

Hi,

From your observation 'tried Oracle's and Microsofts ODBC drivers plus some other connection methods (OCI)' it seems that initial connection set-up is taking too much time. If it were a problem with ODBC you could connect with OCI in reasonable time.

Though you did not mention, I think you are using host naming method for Net8 connection. Host naming method is slow unless you have a DNS server for address resolution (again I am assuming your protocol is TCP/IP). You may try ping with hostname and with IP address. If pinging with hostname takes too much time you are sure that not oracle but address resolution is taking the time.

I would like to follow your problem and solution. My mail address is spectrum_at_bangla.net.

Asif Hasan

In article <37077c2e.81420686_at_news.cgocable.net>,   tony_at_clearviewsystems.com (Tony Stallan) wrote:
> Hi folks,
>
> I have moved my database from O7 - O8 and am encountering very slow
> connection times. My perl based application used to connect on O7 in
> ~0.2 secs, now it takes over 6 secs. A bit shabby when the reason for
> the connection (Select) only takes ~0.5 secs.
>
> I have tried Oracle's and Microsofts ODBC drivers plus some other
> connection methods (OCI) to no avail.
>
> Can anyone help
>
> Thanks
>
> Tony Stallan
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 07 1999 - 09:37:42 CDT