Requete SQL >120secondes

function sql_affiche_graph_annuel ($base_name,$annee)
{
$url_sql="localhost";
$table_sql="base";
$log="root";
$pass="";
	$MONTHS = array("Janvier", "Février", "Mars", "Avril", "Mai",
              "Juin", "Juillet", "Août", "Septembre", "Octobre",
								"Novembre", "Décembre");
	$dimx=300;
	$dimy=200;
	$ind_hc=array(12,32);				/
	$ind_hp=array(12,32);
	
	$A=substr($annee,2,2);

	$db = mysql_connect($url_sql, $log, $pass); // on se connecte à MySQL
	mysql_select_db($table_sql,$db); 	// on sélectionne la base 

	for ($num_mois=1;$num_mois<13;$num_mois++)	
	{
		if (strlen($num_mois)==1)//  Rajoute un Zero au chiffre des unités pr garder la meme lg de la string
			{$num_mois_new="0".$num_mois;}
		else
			{$num_mois_new=$num_mois;}
	
		for ($num_du_jour=1;$num_du_jour<32;$num_du_jour++)
		{
			if (strlen($num_du_jour)==1)//  Rajoute un Zero au chiffre des unités pr garder la meme lg de la string
				{$num_jour_new="0".$num_du_jour;}						
			else
				{$num_jour_new=$num_du_jour;}
				
			$jour_new=($num_jour_new.'/'.$num_mois_new.'/'.$A);
			echo '<b>jour new : '.$jour_new.'</b><BR>';
			// Extraction des valeurs MIN et MAX de HCHC et de HCHP
			$sql = "SELECT MIN(hchc) as min_hc2, MAX(hchc) as max_hc2,MIN(hchp) as min_hp2, MAX(hchp) as max_hp2 FROM $base_name WHERE date='$jour_new'"; 
			$result=mysql_query($sql) or die(mysql_error());
			$min_hc=mysql_result($result,0,'min_hc2');
			$max_hc=mysql_result($result,0,'max_hc2');
			$min_hp=mysql_result($result,0,'min_hp2');
			$max_hp=mysql_result($result,0,'max_hp2');
		
			$ind_hc[$num_mois_new][$num_du_jour]=$max_hc-$min_hc;
			$ind_hp[$num_mois_new][$num_du_jour]=$max_hp-$min_hp;
		}	
	}
	mysql_close($db); 

SELECT MIN(hchc) as min_hc2, MAX(hchc) as max_hc2,MIN(hchp) as min_hp2, MAX(hchp) as max_hp2 ,`date` as date_1  FROM $base_name GROUP BY `date`

$query = "SELECT ................";
$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){
     $day = day($row['date_1']);
     $month = month($row['date_1'];
     $ind_hc[month($month['date_1'])][$day]=$row['max_hc2']-$row['min_hc2'];
     $ind_hp[month($month][$day]=$row['max_hp2']-$row['min_hp2'];
}

mysql_close($db);

while($row = mysql_fetch_array($result)){
    //on recupere le jour et le mois pour faire les indices du tableau
     $day = date('d',$row['date_1']);
     $month = date('m',$row['date_1'];
     $ind_hc[$month][$day]]=$row['max_hc2']-$row['min_hc2'];
     $ind_hp[$month][$day]=$row['max_hp2']-$row['min_hp2'];
}