What is the difference between mysql_connect() and
mysql_pconnect()?




Answers were Sorted based on User's Feedback



What is the difference between mysql_connect() and mysql_pconnect()?..

Answer / jyotisankar pradhan

mysql_connect open a new connection to the database

but mysql_pconnect open a persistant connection to the database

Is This Answer Correct ?    79 Yes 11 No

What is the difference between mysql_connect() and mysql_pconnect()?..

Answer / amita

mysql_connect everytime open a new connection to the database


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.

Is This Answer Correct ?    72 Yes 4 No

What is the difference between mysql_connect() and mysql_pconnect()?..

Answer / jayapirakash

Mysql_connect()->we can colse the datedase
Mysql_pconnect()->we can't close the datadase

Mysql_conect()->opens the database every time page is load
Mysql_pconnect()->Need not to the every time page load

Is This Answer Correct ?    48 Yes 11 No




What is the difference between mysql_connect() and mysql_pconnect()?..

Answer / nishant patel

mysql_pconnect uses less resources, because it does not need
to establish a database connection every time a page is loaded.
persistant = continuously

Is This Answer Correct ?    14 Yes 1 No

What is the difference between mysql_connect() and mysql_pconnect()?..

Answer / pavan

point 4 is absolutely right.

Is This Answer Correct ?    9 Yes 1 No

What is the difference between mysql_connect() and mysql_pconnect()?..

Answer / pramod kumar

1. mysql_pconnect() creates the persistent connection,mysql_connect not create persistent connection to the database.
2. mysql_connect() connection automatically disconnected after execute the code but mysql_pconnect() not.

Is This Answer Correct ?    8 Yes 2 No

What is the difference between mysql_connect() and mysql_pconnect()?..

Answer / sumit

In mysql_pconnect(), ‘p’ stands for persistance connection.

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.


mysql_connect() function, every time it is opening and closing the database connection.

Is This Answer Correct ?    5 Yes 1 No

Post New Answer



More MySQL Interview Questions

Explain MySQL architecture?

1 Answers  


What is difference between inner vs self vs cross?

0 Answers  


what is the difference between between and in operators in mysql?

0 Answers  


How can you filter the duplicate data while retrieving records from the table?

0 Answers  


How to get a list of indexes of an existing table?

0 Answers  






What is “i_am_a_dump” flag in mysql?

0 Answers  


How can we convert between Unix & MySQL timestamps?

0 Answers  


How we can get the current date in mysql?

0 Answers  


What do you mean by % and _ in the LIKE statement?

0 Answers  


How many groups of data types?

0 Answers  


I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

4 Answers  


How do you know if your mysql server is alive?

0 Answers  






Categories