Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between mysql_connect() and
mysql_pconnect()?
- 7 Answers
- 28534 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 ? | 80 Yes | 11 No |
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 |
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 |
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 |
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 |
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 |
What is database clustering in mysql?
How can you change the name of any existing table by using the sql statement?
Where is the myisam table stored?
Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
Write a query to fetch common records between two tables using mysql?
What is the use of ENUM in MySQL?
How do I find the database name in mysql?
What is the purpose of using timestamp data type?
when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field
What does mysql workbench do?
Where MyISAM table will be stored and also give their formats of storage?
How do we use % when performing a search query?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
