mysql_pconnect or mysql_connect??

Anon

What would be best to use ?? Have from 6-25000 pageviews per day.

Anon

It doesn't matter how many hits you got!!

What matters is the sum of queries per script!

Becaus every user that hits your page has to open a new DB connection. Pconnect doesn't mean that you're everytime connected. As soon as the the user hits the reload buttion, he does not pick up any existing connection, there will always a new connection.

So what is the advantage of pconnect?

Pconnect is good for scripts, which have many selects inserts and so on in it because then you can have one connection for this script instead of one connection per Query.

I hope I'm right and clear with everything.

[deleted]

Not quite corrent.

It only depends on the number of connections, not the number of queries.
You can run as many queries as you like using just one connection.

The ONLY advantage of using pconnect is that pconnect keeps connections open, which means that PHP doesn't have to re-open connections all the time. That saves time.

Anon

Mhhh, I don't think so because what I found out is, that when I use pconnect, I have to connect only ONE time (at the start of my script)

I use the following function to achieve this:

function Oracle_Logon () {
if (!$oci_connection) {
echo "!!!!NEW CONNECTION!!!!";
$oracle_user = "xxx";
$oracle_pass = "xxx";
$oci_connection = -1;
$oci_connection = OCIPLogon($oracle_user, $oracle_pass, "xxxx");
return $oci_connection;

}
}

While running a script i see only one time !!!!NEW CONNECTION!!!!, but when reloading I see it again. So pconnect is imho on a script basis and not 'global'

[deleted]

"when I use pconnect, I have to connect only ONE time (at the start of my script)"

Uhm.. what does that have to do with pconnect??

Pconnect is a PHP Internal thing, you have NO control over it.

If you need a database connection, you MUST use OCIPLogon, allways, no matter if you use pconnect or not.
And if you tell php to connect twice, it will connect twice.

The ONLY thing that pconnect does it keep existing connections between the PHP engine and the database open. It does NOT keep connections between your SCRIPT and the database open.