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