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 |
Explain how can we increase the execution time of a php script?
Which framework is best for php development?
Which framework is best for php?
What is var_dump?
What is PEAR?
write the prime number of program?in php
Where is session value stored?
Is ruby on rails php?
Is facebook still in php?
How many ways to include array elements in double-quoted strings using php?
What is a namespace in php?
Tell me how is the ternary conditional operator used in php?