Close   

Admin and announcement forums

    30 Mar 2008
mysql_connect vs mysql_pconnect  
kumar rakesh
create and manage free online surveys with unlimited responses
Online surveys are now basic requirement of everyone who want to review there products or to make studies about anything. But finding a solution who can provide esurveys efficiently is really a big pain. creating an online survey with inefficient tool as irritating and getting survey conducted with limitations on responses is even worse.
cont..
    30 Mar 2008
mysql_connect vs mysql_pconnect  
kumar rakesh
practice interviews and prepare for interviews
in todays changing world every one want to increase there salaries very quickly.
Changes your employer is an very efficient solution for this. But changing employer and company is not so easy.

cont..

Viewed 384 times
Total posts : 0

    20 Dec 2007
mysql_connect vs mysql_pconnect  
Riya Ila
His other forums
mysql_connect vs mysql_pconnect
Mysql_connect() and mysql_pconnect() are both used to open a connection with mysql database.

But there are 2 main differences between mysql_connect() and mysql_pconnect()
1. mysql_pconnect() first tries to find and existing connection from same host and user, if connection found then that connection is used.
2. mysql_pconnect() opens a persistent connection with database and connection does not closes even after script finishes it's execution.


pconnects are expensive in RAM. Make sure you have enough to handle all the children you need and you're ok. If you don't your database server will grind to a halt and die under load.

pconnects can raise no. of connection drastically but it will decrease the time to load page.

if you are using an shared server and your website is highly database oriented  then you should never use mysql_pconnect. it will soon become unmanageable. in this scenario you should use mysql_connect() as it closes the connection automatically after execution of script.

if you are using a dedicated server and you website do not heavily depends on database then you can use mysql_pconnect() to make your site load faster.
mysql_connect vs mysql_pconnect mysql_connect vs mysql_pconnect
mysql_connect vs mysql_pconnect Be first to reply this discussion.
mysql_connect vs mysql_pconnect mysql_connect vs mysql_pconnect mysql_connect vs mysql_pconnect

Login to participate in forums
jump to :
Post reply on this forum

davernginzks 02 Aug 2008

I've recently joined and wanted to introduce myself :)

Comment on this forum
Name :
Email :
Comments :
Legends
mysql_connect vs mysql_pconnect Forums tagged mysql_connect vs mysql_pconnect Forums tagged. But locked for further reply
="mysql_connect Forums locked. can not accept further replies mysql_connect vs mysql_pconnect General forum