468,457 Members | 1,746 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,457 developers. It's quick & easy.

mysql_pconnect usage

Can I use mysql_pconnect on an environment like this? There is just 1
server on which both PHP and MYSQL runs. It is an intranet server. At
any point atleast 2 people will be actively using the server for their
work. If the script uses mysql_pconnect and then the normal user name
and password, will this speed up execution of scripts on the server by
any chance?

Fut

Aug 5 '06 #1
1 1359
WhatsPHP wrote:
Can I use mysql_pconnect on an environment like this? There is just 1
server on which both PHP and MYSQL runs. It is an intranet server. At
any point atleast 2 people will be actively using the server for their
work. If the script uses mysql_pconnect and then the normal user name
and password, will this speed up execution of scripts on the server by
any chance?

Fut
Not significantly. And it will permanently allocate resources the
entire time the server is running.

mysql_pconnect() could be advantageous when you're running hundreds of
connections a second (remember - most connections last just a few
milliseconds) and those resources can be reused immediately. But for
any single connection the time required to establish a connection is
fairly short.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Aug 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Randell D. | last post: by
4 posts views Thread by Yun Guan | last post: by
1 post views Thread by Hal Halloway | last post: by
4 posts views Thread by Angelos | last post: by
1 post views Thread by tom_b | last post: by
11 posts views Thread by =?ISO-8859-1?Q?J=F8rn?= Dahl-Stamnes | last post: by
9 posts views Thread by John Murtari | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by subhajit12345 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.