i applicationID en büyük miktarda bir $ id var ve bu tablo sadece büyümek ve büyümek korkuyor im zaman yani benim kod çalışır ama onun çok hızlı değil.

$x = '0';
$y = '0';
$query0 = "SELECT applicationID 
   FROM app
   WHERE schoolID='$id'";
$result0 = mysql_db_query($aidDB, $query0, $connection);
while ($r0 = mysql_fetch_array($result0)) {
    $query = "SELECT App_Last, App_First, applicationID
     FROM applicant
     WHERE (App_Last IS NOT NULL OR App_First IS NOT NULL) AND applicationID='" . $r0['0'] . "'"; //echo $query;
    $result = mysql_db_query($aidDB, $query, $connection);
    while ($r = mysql_fetch_array($result)) {
        //$temp_array[$x][0]=$r[2];//appid*/
        $query1 = "SELECT DISTINCT applicationID 
    FROM OrderTrack
    WHERE applicationID='" . $r['2'] . "'"; //echo $query1;
        $result1 = mysql_db_query($aidDB, $query1, $connection);
        while ($r1 = mysql_fetch_array($result1)) {
            $temp_array1[$y][0] = "<option name=appid value=\"" . $r1['0'] . "\">" . $r['1'] . "," . $r['0'] . "</option>";
            $temp_array[$x][0] = $r1[0]; //appid cause it to count the distinct amount on customer names may need to change to appid
            $x ++;
            $y ++;
        }
    }
}
}