FUDforum: comp.lang.php » must I close mysql

Home » Imported messages » comp.lang.php » must I close mysql_connect?

Show: Today's Messages :: Polls :: Message Navigator

Re: must I close mysql_connect? [message #179750 is a reply to message #179748]

Mon, 03 December 2012 14:26

M. Strobel
Messages: 386
Registered: December 2011

Karma:

Senior Member

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.

Report message to a moderator

[Message index]

		must I close mysql_connect? By: cngrit0305 on Fri, 30 November 2012 14:15
		Re: must I close mysql_connect? By: Jerry Stuckle on Fri, 30 November 2012 14:34
		Re: must I close mysql_connect? By: cngrit0305 on Sat, 01 December 2012 07:43
		Re: must I close mysql_connect? By: M. Strobel on Mon, 03 December 2012 09:30
		Re: must I close mysql_connect? By: Jerry Stuckle on Mon, 03 December 2012 11:52
		Re: must I close mysql_connect? By: M. Strobel on Mon, 03 December 2012 14:26
		Re: must I close mysql_connect? By: Jerry Stuckle on Mon, 03 December 2012 16:09
		Re: must I close mysql_connect? By: M. Strobel on Mon, 03 December 2012 19:05

Previous Topic:	[Windows] php-cgi.exe can't find extension
Next Topic:	when receiving the mail(php mail function), the variable's last value is getting converted to $ or # replacing the digit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 12:52:25 GMT 2024

Total time taken to generate the page: 0.04008 seconds