Open db connection

Hi.

I'm trying to close unnecessary db connection to reduce the concurrent
connection. Is there any way I can find the open connection?

Thanks.

Ben

Re: Open db connection

On Aug 6, 11:41 pm, "Ben Sehara" wrote:
> Hi.
>
> I'm trying to close unnecessary db connection to reduce the concurrent
> connection. Is there any way I can find the open connection?
>

almost certainly..
however you didn't specify what type of db your using, or how you
opened the connection.
I'll venture to guess you want to see
http://www.php.net/function.mysql-close.php
this is unnecessary as it's closed when the script ends..
and note that mysql_connect() returns the connection resource... so
keep track of it.

Re: Open db connection

Sorry, but you had a good guess. Yes, it is MySQL.
I didn't know it's closed when it ends. What a nice feature!

Thanks.


"BKDotCom" wrote in message
news:1186462432.168481.265310@x40g2000prg.googlegroups.com.. .
> On Aug 6, 11:41 pm, "Ben Sehara" wrote:
>> Hi.
>>
>> I'm trying to close unnecessary db connection to reduce the concurrent
>> connection. Is there any way I can find the open connection?
>>
>
> almost certainly..
> however you didn't specify what type of db your using, or how you
> opened the connection.
> I'll venture to guess you want to see
> http://www.php.net/function.mysql-close.php
> this is unnecessary as it's closed when the script ends..
> and note that mysql_connect() returns the connection resource... so
> keep track of it.
>