Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #7681

Re: must I close mysql_connect?

Show all headers | View raw

Am 03.12.2012 12:52, schrieb Jerry Stuckle:
> On 12/3/2012 4:30 AM, M. Strobel wrote:
>> Am 30.11.2012 15:15, schrieb cngrit:
>>> In my script,I use mysql_connect to get a connection with mysql,now I want to
>>> know,after I used it ,I must to close it, or ignore it?
>>>
>>> if this connection will be used many times,i need to close it after the last time,
>>> or nothing to do?
>>>
>>> usually,which function you will use，mysql_connect or mysql_pconnect?
>>>
>> mysql_pconnect is broke, don't use it.
>>
>> mysql is obsolete, rather use mysqli, or even better, PDO.
>>
>> /Str.
>>
> 
> What's broke about mysql_pconnect() (other than the fact it has been deprecated)? 
> (I'm not saying he should use it - I just want to know why you claim it's broken.

I experienced this once myself with a system I started to administer, the old admin
tried to optimize with pconnect, and it brought the web site to a halt. Then I read
somewhere it was broke, and never used it again. The only reference I have is that a
search for "mysql_pconnect issues" yields 24000 hits, and "mysqli_pconnect issues"
2400. Of course most links are quite old.

Then I think the optimization achieved with pconnect is largely overestimated, and a
risk if you use temp tables. Very often you can optimize your DB connection much more
by using the local pipe instead of a local IP connection.

> Also, whether to use mysqli or pdo is a matter of choice - there are many reasons why
> someone might want mysqli.

Sure, and you can base your choice on
http://de2.php.net/manual/en/mysqlinfo.api.choosing.php , but in a newsgroup you get
good advice, not only technical references.

/Str.

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

must I close mysql_connect? cngrit <cngrit0305@gmail.com> - 2012-11-30 06:15 -0800
  Re: must I close mysql_connect? Jerry Stuckle <jstucklex@attglobal.net> - 2012-11-30 09:34 -0500
    Re: must I close mysql_connect? cngrit <cngrit0305@gmail.com> - 2012-11-30 23:43 -0800
  Re: must I close mysql_connect? "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-12-03 10:30 +0100
    Re: must I close mysql_connect? Jerry Stuckle <jstucklex@attglobal.net> - 2012-12-03 06:52 -0500
      Re: must I close mysql_connect? "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-12-03 15:26 +0100
        Re: must I close mysql_connect? Jerry Stuckle <jstucklex@attglobal.net> - 2012-12-03 11:09 -0500
          Re: must I close mysql_connect? "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-12-03 20:05 +0100

csiph-web