ResumesInn
Welcome  ,
Interview Questions >> PHP >> Difference between mysql_connect and mysql_pconnect?
Next Question Previous Question

Difference between mysql_connect and mysql_pconnect?



  Prasanjeet Ghosh wrote ...

mysql_connect() and mysql_pconnect() both are working for database connection but with little difference. In mysql_pconnect(), ‘p’ stands for persistance connection.

When we are using mysql_connect() function, every time it is opening and closing the database connection, depending on the request .

But in case of mysql_pconnect() function,
First, when connecting, the function would try to find a (persistent) connection 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 connection will remain open for future use (mysql_close() will not close connection established by mysql_pconnect()).

mysql_pconncet() is useful when you have a lot of traffice on your site. At that time for every request it will not open a connection but will take it from the pool. This will increase the efficiency of your site. But for general use mysql_connect() is best.

  Joseph Ranjan wrote ...
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()).
  Joseph Ranjan wrote ...
First, when connecting, the function would first try to find a (persistent) link thats 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.


Login to write answer for this question !
Want to place your ads in this website ?
50USD Per Month for single placement. Contact Us
All Rights Reserved . Developed by SJRANJAN