top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How mysql_connect and mysql_pconnect differ from each other?

0 votes
437 views
How mysql_connect and mysql_pconnect differ from each other?
posted Jun 20, 2014 by Amritpal Singh

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+1 vote

The difference between mysql_connect() and mysql_pconnect, it is simply like a shop when u entering in shop you will open the door and take your iteam come out and close the door that is called connect() in mysql the connection to the mysql database will be automatically closed when the script terminates. When the door of the shop is already opened and never close it is called pconnect (), open a connection with mysql_pconnect(), the connection will not be closed and will “persist” for future use. Mysql_connect opens up a database connection every time a page is loaded. Mysql_pconnect opens up a connection, and keeps it open across multiple requests. Mysql_pconnect uses fewer resources, because it does not need to establish a database connection every time a page is loaded. 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()).

answer Jun 22, 2014 by Vrije Mani Upadhyay
0 votes

Mysql_pconnect() makes a persistent connection to the database which means a SQL link that do not close when the execution of your script ends. mysql_connect()provides only for the new database connection. While using mysql_pconnect , 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... 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.

answer Jun 23, 2014 by Rahul Mahajan
...