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 #169707 is a reply to message #169699]

Thu, 23 September 2010 17:01

Robert Hairgrove
Messages: 19
Registered: September 2010

Karma:

Junior Member

Jerry Stuckle wrote:
> 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.

Many other popular languages such as Java, C# and C++ also have what is
known as a "garbage collection". With C++, of course, you can opt out of
it (or into it, depending on the platform) and handle allocations and
deallocations yourself. And depending on the platform, this may or may
not be a good idea.

If you don't trust PHP to get it right in cases where it is documented
to work correctly, then you need to file a bug report with the developers.

If you STILL don't trust them to get it right, then why are you using
the language at all?

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:35:19 GMT 2024

Total time taken to generate the page: 0.04386 seconds