Yes, the database is humongous and keeps oozing. One table has more than 200,000 rows is is growing by 2,500 entries a day. The other one has about 120,000 records. All of the hints to speed up the search process are greatly appreciated. If I could wrap my brain around making the tables relational, that would help as well. Using prepared statements has helped tremendously. The script has gone from paint-drying speed to less than 15 seconds.
However, here's one bit of code which really carries the load that i haven't figured out how to accelerate:
if ($result4 = $mysqli->query("SELECT IdNum FROM CallVolume WHERE ANI = '$CellNum' AND WorkDate = '$IncDate'"))
{
$CallCount["$Count"] = $result4->num_rows;
$result4->close();
$SubCallCount = $SubCallCount + $CallCount["$Count"];
}
Is speeding this process up even possible?
tyvm fer da hep