What is the advantge and disadvantage of mysql_connet() and
mysql_pconnect() ? in which condition will you use
mysql_connect() and mysql_pconnect().
Answer Posted / praveen
mysql_pconnect() will maintain a persistent connection to
the database. whenever your script calls the connect to
database function, it first searches already existing
connections to the database and if exists it will use the
same connection to connect to the database, if not it will
open a new connection to the database. ie. Connection is
Persistent
where as mysql_connect() function will establish a new
connection whenever a connection to database needed, and
after executing the script, this function disconnects the
connection. ie. connection is not a persistent one.
mysql_pconnect() function is used where your site has a
Heavy Traffic and where as mysql_connect() function is used
when there is moderate/less traffic to your site.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What are the two types of variables?
What is session data?
Which function is used to read a file removing the html and php tags in it upwork?
What is php regular expression?
Declare a new variable in php equal to the number 3;
Which parts of php are case sensitive?
How to calculate the difference between two dates using php?
Explain what is the difference between for and foreach?
Tools used for drawing er diagrams?
What does addslashes do in php?
How can I learn php fast?
What are the three parts of an http request?
How can you increase the maximum execution time of a script in php?
Differentiate between php5 and php7?
What is the use of mysql_real_escape_string() function?