| must I close mysql_connect? [message #179735] |
Fri, 30 November 2012 14:15  |
cngrit0305
Messages: 4
Registered: November 2012
Karma: 0
|
Junior Member |
|
|
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 14:34  |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
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 07:43 |
cngrit0305
Messages: 4
Registered: November 2012
Karma: 0
|
Junior Member |
|
|
在 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 09:30 |
M. Strobel
Messages: 386
Registered: December 2011
Karma: 0
|
Senior Member |
|
|
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 11:52 |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
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 14:26 |
M. Strobel
Messages: 386
Registered: December 2011
Karma: 0
|
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.
|
|
|
|
| Re: must I close mysql_connect? [message #179752 is a reply to message #179750] |
Mon, 03 December 2012 16:09 |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
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 19:05 |
M. Strobel
Messages: 386
Registered: December 2011
Karma: 0
|
Senior Member |
|
|
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.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]