FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » must I close mysql_connect?
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
must I close mysql_connect? [message #179735] Fri, 30 November 2012 09:15 Go to next message
cngrit0305 is currently offline  cngrit0305
Messages: 4
Registered: November 2012
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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?
Re: must I close mysql_connect? [message #179736 is a reply to message #179735] Fri, 30 November 2012 09:34 Go to previous messageGo to next message
Jerry Stuckle is currently offline  Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
On 11/30/2012 9:15 AM, cngrit wrote:
> 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?
>

It's always good programming practice to clean up after yourself. This
means closing connections when you're done with them.

As for connecting - do you need a persistent connection? If so, why?
If you can't provide good answers to those questions, you shouldn't be
using mysql_pconnect().

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
Re: must I close mysql_connect? [message #179739 is a reply to message #179736] Sat, 01 December 2012 02:43 Go to previous messageGo to next message
cngrit0305 is currently offline  cngrit0305
Messages: 4
Registered: November 2012
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
在 2012年11月30日星期五UTC+1下午3时34分15秒,Jerry Stuckle写道:
> On 11/30/2012 9:15 AM, cngrit wrote: > 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? > It's always good programming practice to clean up after yourself. This means closing connections when you're done with them. As for connecting - do you need a persistent connection? If so, why? If you can't provide good answers to those questions, you shouldn't be using mysql_pconnect(). -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex(at)attglobal(dot)net ==================

en,thank you very much,now,i know how to do.
Re: must I close mysql_connect? [message #179747 is a reply to message #179735] Mon, 03 December 2012 04:30 Go to previous messageGo to next message
M. Strobel is currently offline  M. Strobel
Messages: 386
Registered: December 2011
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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.
Re: must I close mysql_connect? [message #179748 is a reply to message #179747] Mon, 03 December 2012 06:52 Go to previous messageGo to next message
Jerry Stuckle is currently offline  Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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.

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

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
Re: must I close mysql_connect? [message #179750 is a reply to message #179748] Mon, 03 December 2012 09:26 Go to previous messageGo to next message
M. Strobel is currently offline  M. Strobel
Messages: 386
Registered: December 2011
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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.
Re: must I close mysql_connect? [message #179752 is a reply to message #179750] Mon, 03 December 2012 11:09 Go to previous messageGo to next message
Jerry Stuckle is currently offline  Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
On 12/3/2012 9:26 AM, M. Strobel wrote:
> 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.
>

Just because the website came to a halt doesn't mean mysql_pconnect() is
broken. There are a lot of things to consider when using persistent
connections with *any* database - not the least being the system
resources that are tied up even when there are no active connections to
the database.

Most people who try to use persistent connections have no idea what they
are doing. It takes much more than just changing mysql_connect() to
mysql_pconnect().

> 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.
>

It can have advantages in heavily used systems (i.e. 100+ pages/sec.
using the database). But you need to know what you're doing and how to
tune the entire system.

>> 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.
>
>

Yes, and *your opinion* is to use PDO. You should say it is only your
opinion. Others have different opinions.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
Re: must I close mysql_connect? [message #179758 is a reply to message #179752] Mon, 03 December 2012 14:05 Go to previous message
M. Strobel is currently offline  M. Strobel
Messages: 386
Registered: December 2011
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Am 03.12.2012 17:09, schrieb Jerry Stuckle:
> On 12/3/2012 9:26 AM, M. Strobel wrote:
>> Am 03.12.2012 12:52, schrieb Jerry Stuckle:
--cut--
>>> 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.
>>
>>
>
> Yes, and *your opinion* is to use PDO. You should say it is only your opinion.
> Others have different opinions.

<opinion>
Every post to a newsgroup is either a hint, or an opinion. Every reader must find out
himself what is useful information and what not, by relating the pronounced positions
with his knowledge about the poster, the subject, and other sources of information.
</opinion>

I have had too many students copying from wikipedia wrong or just confusing sentences
to give everybody this advice for every source of information.

End of prayer.

/Str.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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) ] [ RSS ]

Current Time: Fri Oct 20 08:43:55 EDT 2017

Total time taken to generate the page: 0.00583 seconds