Fine Tune Script/Speed it up. Too many Mysql_Connects?

[jonno946]

Hi there,

I have a rather complex script up and running that connects to 3 individual databases.

The thing is i am a bit worried how this will effect load times and my server resources.

I initially tried to do the following at the start of my page:

$conn1 = mysql_connect(....
$conn2 = mysql_connect(....
$conn3 = mysql_connect(....

However for some reason only the first connection worked?

Also, i have 2 main parts - layout.php and layout_functions.php which contains functions for the dynamic content. Currently i am connecting to my database like this:

function test() {

$conn1 = mysql_connect(....

mysql_close($conn1);

}

function test2() {

$conn2 = mysql_connect(....

mysql_close($conn2);

}

function test3() {

$conn3 = mysql_connect(....

mysql_close($conn3);

$conn1 = mysql_connect(....

mysql_close($conn1);

}

Firstly is this a bad way of doing this? Is there a way i can globally define all 3 of my database connections to stop me connecting/disconnecting constantly?

Secondly, i believe during the execution of my script i mysql_close the currect connection and start another roughly about 15 - 20 times. Is this healthy?

My page load times do seem to be lagging sightly (not majorly), and the site is going life in a few weeks so wanted to see if i could speed it up a bit/fine tune it.

Thanks.

Jonno.

[rachel2004]

If it's not necessary to close the MySQL connections, maybe just use mysql_pconnect() once at the beginning of the script and all subsequent communication to the db will rely on that single connection.

[jonno946]

Hmm read the manual but it all seems a bit over my head! Would this sort of thing work...?

<?php

$conn1 = mysql_pconnect(...);
$conn2 = mysql_pconnect(...);
$conn3 = mysql_pconnect(...);
mysql_select_db('database1', $conn1);
mysql_select_db('database2', $conn2);
mysql_select_db('database3', $conn3);

function test1() {

$query = mysql_query("...", $conn1);

}

function test2() {

$query2 = mysql_query("...", $conn2);

}

function test2() {

$query3 = mysql_query("...", $conn3);

}

?>

Thanks 🙂

Jonno

[Drakla]

in your:

$conn1 = mysql_pconnect(...);
$conn2 = mysql_pconnect(...);
$conn3 = mysql_pconnect(...);

are you connecting to the same server with the same username and password for each connection? If so are you specifying the new connection parameter? If you're not it'll return the same connection resource for conn2 and conn3 as the first one opened, so you have to use it if you want 3 genuinely different connection resources.

Connections can take a huge time compared to queries, so just open them globally and then refer to the globals in your functions if you can.