What is the difference between mysql_connect and
mysql_pconnect ? Which one is good in terms of performance ?

Answers were Sorted based on User's Feedback



What is the difference between mysql_connect and mysql_pconnect ? Which one is good in terms of pe..

Answer / brijendra

mysql_connect opens a normal connections to mysql database.
mysql_pconnect opens a persistant connection i.e. if there
is any connection open in the script it will use that
connection not making a new connection each time.
at very high traffic enviornment mysql_connect provides
better performance

Is This Answer Correct ?    38 Yes 3 No

What is the difference between mysql_connect and mysql_pconnect ? Which one is good in terms of pe..

Answer / ranjan goyal

In addition to what Brijendra said, persistanty connections
are limited per server so limited number of people will
have access to the website so infact it will stop high
traffic that implies if we say assuem that our site will
have high traffic then we must not use persistent
connections. Persistent connections should be used only
where we only have limited number of users

Is This Answer Correct ?    21 Yes 3 No

What is the difference between mysql_connect and mysql_pconnect ? Which one is good in terms of pe..

Answer / modi

mysql_pconnect Open a persistent connection to a MySQL server

First, when connecting, the function would first try to find
a (persistent) link that's already open with the same host,
username and password. If one is found, an identifier for it
will be returned instead of opening a new connection...

Second, the connection to the SQL server will not be closed
when the execution of the script ends. Instead, the link
will remain open for future use (mysql_close() will not
close links established by

Is This Answer Correct ?    11 Yes 1 No

What is the difference between mysql_connect and mysql_pconnect ? Which one is good in terms of pe..

Answer / amit

The mysql_pconnect() function opens a persistent MySQL
connection.

This function returns the connection on success, or FALSE
and an error on failure. You can hide the error output by
adding an '@' in front of the function name.

mysql_pconnect() is much like mysql_connect(), but with two
major differences:

•This function will try to find a connection that's already
open, with the same host, username and password. If one is
found, this will be returned instead of opening a new
connection
•The connection will not be closed when the execution of
the script ends (mysql_close() will not close connection
opened by mysql_pconnect()). It will stay open for future
use

Is This Answer Correct ?    7 Yes 2 No

Post New Answer

More PHP Interview Questions

Is overloading possible in php?

0 Answers  


What is singleton class in php?

0 Answers  


Write a program to upload a file in php?

0 Answers  


what is this error "Call to unsupported or undefined function mysql_connect();" and when you will get this?

2 Answers  


What are the new features in php 7?

0 Answers  






What is the default session time in PHP and how can I change it?

13 Answers   VirtualSoft,


What type of language is php?

0 Answers  


What is meant by variable variables in php?

0 Answers  


What is the phpstorm?

0 Answers  


What is list function with their uses.

0 Answers  


What is the meaning of symbol '$' in jquery?

0 Answers  


How many escape sequences are recognized in double-quoted strings?

0 Answers  


Categories