Q . What is the difference between MySQL persistent and non-persistent connection?

@mit $ingh. asked, Feb 14 ' 2015

Please Explain both of them....

  • MySQL
  • persistent
  • non-persistent

1 Answers

Persistent connections are kept open indefinitely. Non-persistent connections are not.

mysql_pconnect() acts very much like mysql_connect() with two major differences.

mysql_pconnect() acts very much like mysql_connect() with two major differences.

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 mysql_pconnect()).

This type of link is therefore called 'persistent'.

Leave a Ansewer