Dear Mr. Sterin,
I'm using ORACLE-DBD to connect with my Oracle8i. After 100 simultaneous
process/connection, the software and database (listener) is hangs and
sometimes
return a message: 'return zero length value'.
We limit the simultaneous connection to our database up to 200, which is
far beyond the troubled state. Is it the Perl-DBI which had the limit?
Yours Truly,
Alex Kusuma Tjahjana
Phone: +62 +21 +515 3268 / 69
email: [EMAIL PROTECTED]
-----Original Message-----
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 22, 2001 11:01 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Max connection of Perl-DBI
Please don't send emails not pertaining to the development of DBI to
[EMAIL PROTECTED] If you read the directions before signing up, you would
have read the purpose of each list.
See comments below...
> -----Original Message-----
> From: Alex Kusuma Tjahjana [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 5:56 AM
> To: [EMAIL PROTECTED]
> Subject: Max connection of Perl-DBI
>
>
> Dear all,
>
> I have a little problem regarding connection on a Perl-DBI.
>
> I already settle a remote database connection from my web server to
> my database server. After several time, my software and my web server
> is stop responding requet from clients. My software heavily rely on the
> database connection. Yes, the traffic between my web and database
What database are you using? It's hard to tell from your message:-)
> connection is very dense. And it seems that after the number of
> Perl process (about 100 simultaneous processes) on my web server,
> the software and the database is stop responding.
Stops responding? You mean hangs or errors out?
>
> PS: the connection has been running well for 1 year and several months
> and all this time, nothing happened. However, it is true that
> current load is very peak that usual.
>
> My question: Is Perl-DBI have an upper limit of simultaneous
> database connection? If there is any, what is limit and how much?
Your database software should have a limit of simultaneous connections and
you will probably need to change that.
What is the error message you are getting?
>
> Thank you.
> If there is any further question or information you need to know,
> do not hesitate to contact me.
>
>
> Yours Truly,
>
> Alex Kusuma Tjahjana
> Phone: +62 +21 +515 3268 / 69
> email: [EMAIL PROTECTED]
