What is the advantge and disadvantage of mysql_connet() and
mysql_pconnect() ? in which condition will you use
mysql_connect() and mysql_pconnect().
- 2 Answers
- 9481 Views
- Avanigoradia, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
mysql_pconnect() will maintain a persistent connection to
the database. whenever your script calls the connect to
database function, it first searches already existing
connections to the database and if exists it will use the
same connection to connect to the database, if not it will
open a new connection to the database. ie. Connection is
Persistent
where as mysql_connect() function will establish a new
connection whenever a connection to database needed, and
after executing the script, this function disconnects the
connection. ie. connection is not a persistent one.
mysql_pconnect() function is used where your site has a
Heavy Traffic and where as mysql_connect() function is used
when there is moderate/less traffic to your site.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / ltmert
If you're connecting to a MySQL database in your PHP
application, you'll find that there are two alternative
connctions - mysql_connect which establishes a new
connection "each time" and mysql_pconnect which uses
persistant connections. Which should you use?
Mysql_connect opens a new connection each time a PHP page is
called up, and closes the connection down again at the end
of the request. It's ideal for pages that don't have a heavy
usage - doesn't need tuning, is straightforward internally.
If you compare MySQL to a shop, this is the connection that
you would use for a small shop where the door is opened each
time a new customer wishes to enter.
Mysql_pconnect will also open a new connection when a PHP
page is called up (at any rate, it will the first time after
a server reboot), but it will NOT close the connection at
the end of the request - instead, it will save it in a
connection pool so that a subsequent request can continue to
use the same connection. It's intended for pages that do
have a heavy usage - where the resources burn up by opening
and closing connections every time might have a severe
effect on performance. If your local supermarket had a door
that was opened each time someone went in and out, there
would be a lot of needless opening and closing going on -
better to leave it open and let a whole lot of people in and
out at the same time.
But mysql_pconnect does require some tuning of the servers
and you may need to limit the numbers of connections /
children and configure timeouts and how to deal with idle
children. The PHP website includes an overview of this to
get you started.
Finally, it is worth stressing what a persistant connect
does NOT give you. It does NOT give you sessions. It does
NOT give you a per-site-visitor login. It does NOT give you
any extra functioanllity. What it does give you - in the
right circumstances - is an efficiency improvement.
| Is This Answer Correct ? | 8 Yes | 1 No |
What is the difference between mysql_connect and mysql_pconnect ? Which one is good in terms of performance ?
Does wordpress still use php?
How to increase session life time using PHP?
Tell us how to redirect a page in php?
Explain what does the unlink() function means?
What is the use of namespace in php?
In how many ways we can retrieve the date in the result set of mysql using PHP?
What is php and why it is used?
What is $_ post in php?
What is the method to execute a php script from the command line?
If the variable $var1 is set to 10 and the $var2 is set to the character var1, what's the value of $$var2?
Why do we use polymorphism in php?
PHP 
