Difference between mysql_connect and mysql_pconnect in php?
Answers were Sorted based on User's Feedback
Answer / md amanullah
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 ? | 11 Yes | 1 No |
Answer / aatit
The following are the differences -
- A new connection is established to the database by using
mysql_connect, where as mysql_pconnect opens a persistant
connection to the database.
- mysql_connect can be used to close the connection, where as
mysql_pconnect can not close the connection.
- Database is opened every time when the page is loaded by
mysql_connect. Whereas by using mysql_pconnect, database need
not be connected every time.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is Apache's configuration file typically called?
How can you associate a variable with a session?
How can we encrypt the username and password using PHP?
3 Answers Rushmore Consultancy,
How to open a file in php?
Is array empty php?
What is the difference between Session and Cookie?
Explain $_FILES Superglobal Array?
What is the use of hooks?
What is pdo in php why use?
Why is php used?
Tell me will a comparison of an integer 12 and a string "13" work in php?
Where are the session values stored?