I have developed a script that checks against some data in about 8 tables in a PostgreSQL database and then displays the appropriate data and images. I'm thinking that it is doing too much processing for the database queries, but i can't tell and don't know of any other way to do it. Can someone help me out, or give me a few pointers on this. I pasted my Script below:
Thanks,
Cameron Seader
This script is a little over 400 lines some of it is template stuff, so i removed that stuff and left the PHP in there. It moves so slow like a min and a half or so. no matter how fast the machine.
<?php
//Connection statement
require_once('../Connections/acquisuite.php');
require_once('../functions/tblfunc.php');
// begin Recordset
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($HTTP_GET_VARS['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $HTTP_GET_VARS['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 $maxRows_Recordset1;
$query_Recordset1 = "SELECT FROM tbl_devices";
$Recordset1 = $acquisuite->SelectLimit($query_Recordset1, $maxRows_Recordset1, $startRow_Recordset1) or die($acquisuite->ErrorMsg());
if (isset($HTTP_GET_VARS['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $HTTP_GET_VARS['totalRows_Recordset1'];
} else {
$all_Recordset1 = $acquisuite->SelectLimit($query_Recordset1) or die($acquisuite->ErrorMsg());
$totalRows_Recordset1 = $all_Recordset1->RecordCount();
}
$totalPages_Recordset1 = (int)(($totalRows_Recordset1-1)/$maxRows_Recordset1);
// end Recordset
// begin Recordset
$query_Recordset2 = "SELECT * FROM t444d500009b5_1_6 ORDER BY utctime DESC LIMIT 1";
$Recordset2 = $acquisuite->SelectLimit($query_Recordset2) or die($acquisuite->ErrorMsg());
$totalRows_Recordset2 = $Recordset2->RecordCount();
// end Recordset
// begin Recordset
$query_Recordset3 = "SELECT * FROM t444d500009b5_2_6 ORDER BY utctime DESC limit 1";
$Recordset3 = $acquisuite->SelectLimit($query_Recordset3) or die($acquisuite->ErrorMsg());
$totalRows_Recordset3 = $Recordset3->RecordCount();
// end Recordset
// begin Recordset
$query_Recordset4 = "SELECT * FROM t444d500009b5_3_6 ORDER BY utctime DESC LIMIT 1";
$Recordset4 = $acquisuite->SelectLimit($query_Recordset4) or die($acquisuite->ErrorMsg());
$totalRows_Recordset4 = $Recordset4->RecordCount();
// end Recordset
// begin Recordset
$query_Recordset5 = "SELECT * FROM t444d500009b5_4_6 ORDER BY utctime DESC LIMIT 1";
$Recordset5 = $acquisuite->SelectLimit($query_Recordset5) or die($acquisuite->ErrorMsg());
$totalRows_Recordset5 = $Recordset5->RecordCount();
// end Recordset
// begin Recordset
$query_Recordset6 = "SELECT * FROM t444d500009b5_5_6 ORDER BY utctime DESC LIMIT 1";
$Recordset6 = $acquisuite->SelectLimit($query_Recordset6) or die($acquisuite->ErrorMsg());
$totalRows_Recordset6 = $Recordset6->RecordCount();
// end Recordset
// begin Recordset
$query_Recordset7 = "SELECT * FROM t444d500009b5_6_6 ORDER BY utctime DESC LIMIT 1";
$Recordset7 = $acquisuite->SelectLimit($query_Recordset7) or die($acquisuite->ErrorMsg());
$totalRows_Recordset7 = $Recordset7->RecordCount();
// end Recordset
// begin Recordset
$query_Recordset8 = "SELECT * FROM t444d500009b5_250_9 ORDER BY utctime DESC LIMIT 1";
$Recordset8 = $acquisuite->SelectLimit($query_Recordset8) or die($acquisuite->ErrorMsg());
$totalRows_Recordset8 = $Recordset8->RecordCount();
// end Recordset
//PHP ADODB document - made with PHAkt 2.5.0?>
<?php
while (!$Recordset1->EOF) {
alternate_rows();
?>
<td width="10" align="center" nowrap>
<?php
$reddot = '../graphics/alarm.gif';
$greendot = '../graphics/green.gif';
$redx = '../graphics/redx.gif';
switch ($Recordset1->Fields('dev_name'))
{
case 'AcquiSuite 8811-1 ':
echo "<img src=\"";
if ($Recordset8->Fields('error') != 0)
echo $redx;
elseif ($Recordset8->Fields('highalarm') == 0)
echo $greendot;
else
echo $reddot;
echo "\">";
break;
case 'Panel A2 B1':
echo "<img src=\"";
if ($Recordset4->Fields('error') != 0)
echo $redx;
elseif ($Recordset4->Fields('highalarm') == 0)
echo $greendot;
else
echo $reddot;
echo "\">";
break;
case 'Panel A2 B2 ':
echo "<img src=\"";
if ($Recordset3->Fields('error') != 0)
echo $redx;
elseif ($Recordset3->Fields('highalarm') == 0)
echo $greendot;
else
echo $reddot;
echo "\">";
break;
case 'Panel A2 B3':
echo "<img src=\"";
if ($Recordset2->Fields('error') != 0)
echo $redx;
elseif ($Recordset2->Fields('highalarm') == 0)
echo $greendot;
else
echo $reddot;
echo "\">";
break;
case 'Panel A1 A1':
echo "<img src=\"";
if ($Recordset5->Fields('error') != 0)
echo $redx;
elseif ($Recordset5->Fields('highalarm') == 0)
echo $greendot;
else
echo $reddot;
echo "\">";
break;
case 'Panel A1 A2':
echo "<img src=\"";
if ($Recordset6->Fields('error') != 0)
echo $redx;
elseif ($Recordset6->Fields('highalarm') == 0)
echo $greendot;
else
echo $reddot;
echo "\">";
break;
case 'Panel A1 A3':
echo "<img src=\"";
if ($Recordset7->Fields('error') != 0)
echo $redx;
elseif ($Recordset7->Fields('highalarm') == 0)
echo $greendot;
else
echo $reddot;
echo "\">";
break;
default: printf("<img src=\"%s\">", $redx); break;
}
?>
</td>
<td nowrap>
<div align="center"><font color="#000000">
<?php
$acqui = 'acquidata.php';
$pa1a1 = 'pana1a1.php';
$pa1a2 = 'pana1a2.php';
$pa1a3 = 'pana1a3.php';
$pa2b1 = 'pana2b1.php';
$pa2b2 = 'pana2b2.php';
$pa2b3 = 'pana2b3.php';
switch ($Recordset1->Fields('dev_name'))
{
case 'AcquiSuite 8811-1 ': printf("<a class=\"two\" href=\"%s\">AcquiSuite 8811-1</a>", $acqui); break;
case 'Panel A2 B1': printf("<a class=\"two\" href=\"%s\">Panel A2 B1</a>", $pa2b1); break;
case 'Panel A2 B2 ': printf("<a class=\"two\" href=\"%s\">Panel A2 B2</a>", $pa2b2); break;
case 'Panel A2 B3': printf("<a class=\"two\" href=\"%s\">Panel A2 B3</a>", $pa2b3); break;
case 'Panel A1 A1': printf("<a class=\"two\" href=\"%s\">Panel A1 A1</a>", $pa1a1); break;
case 'Panel A1 A2': printf("<a class=\"two\" href=\"%s\">Panel A1 A2</a>", $pa1a2); break;
case 'Panel A1 A3': printf("<a class=\"two\" href=\"%s\">Panel A1 A3</a>", $pa1a3); break;
}
?>
</font></div></td>
</tr>
<?php
$Recordset1->MoveNext();
}
?>
<?php
$Recordset1->Close();
$Recordset2->Close();
$Recordset3->Close();
$Recordset4->Close();
$Recordset5->Close();
$Recordset6->Close();
$Recordset7->Close();
$Recordset8->Close();
?>
