FUDforum: comp.lang.php

Home » Imported messages » comp.lang.php » I need Help

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

Re: I need Help [message #169699 is a reply to message #169696]

Thu, 23 September 2010 13:20

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 9/23/2010 3:56 AM, Robert Hairgrove wrote:
> Robert Hairgrove wrote:
>> Jerry Stuckle wrote:
>>> On 9/22/2010 4:46 PM, Robert Hairgrove wrote:
>>>> Patrick Ehrmann wrote:
>>>> > mysql_close ($verbindung);
>>>>
>>>> PHP takes care of this automatically, I believe.
>>>>
>>>
>>> Never a good idea to allow PHP to close the connection. Close it
>>> yourself when you're done!
>>
>> This is true for persistent connections. However:
>>
>> http://ch2.php.net/manual/en/function.mysql-close.php
>>
>> "(...) Using mysql_close() isn't usually necessary, as non-persistent
>> open links are automatically closed at the end of the script's
>> execution. See also freeing resources."
>
> Looking at some of the user comments, it seems that PHP applications on
> Windows connecting via TCP might have a problem in this regard. However,
> if you are connecting to the DB on localhost, e.g. on a Linux server
> hosting a website, then this shouldn't be a problem.
>
> From reading the rest of the problems posted there by users, looks like
> it is difficult to get it right -- best to let PHP take care of it
> unless there is a compelling reason otherwise.

Except for extremely rare instances, you shouldn't use persistent
connections in PHP. They will almost always harm performance more than
they will help.

And whether the script will close connections when it ends or not, it is
still not a good idea to depend on the system to close it for you. This
is true with all languages and all databases.

Good programming practices means to always clean up after yourself and
don't depend on someone else to do it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

Report message to a moderator

[Message index]

		I need Help By: Patrick Ehrmann on Wed, 22 September 2010 20:23
		Re: I need Help By: me on Wed, 22 September 2010 20:38
		Re: I need Help By: Robert Hairgrove on Wed, 22 September 2010 20:46
		Re: I need Help By: Jerry Stuckle on Thu, 23 September 2010 03:24
		Re: I need Help By: Beauregard T. Shagnas on Thu, 23 September 2010 04:17
		Re: I need Help By: Michael Fesser on Thu, 23 September 2010 19:44
		Re: I need Help By: Beauregard T. Shagnas on Thu, 23 September 2010 20:37
		Re: I need Help By: Robert Hairgrove on Thu, 23 September 2010 07:47
		Re: I need Help By: Robert Hairgrove on Thu, 23 September 2010 07:56
		Re: I need Help By: Jerry Stuckle on Thu, 23 September 2010 13:20
		Re: I need Help By: Robert Hairgrove on Thu, 23 September 2010 17:01
		Re: I need Help By: Jerry Stuckle on Thu, 23 September 2010 19:19
		Re: I need Help By: Robert Hairgrove on Thu, 23 September 2010 20:19
		Re: I need Help By: Jerry Stuckle on Thu, 23 September 2010 21:59

Previous Topic:	Book problems and solution for windows 7
Next Topic:	Syntax for array?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 08:32:26 GMT 2024

Total time taken to generate the page: 0.04289 seconds