Geschwindigkeit erhöhen ? PHP Optimieren ?

[EKKi]

Mahlzeit,

$antworten = "SELECT id,thread,byuser,text,datum,zeit,posttime FROM forum_antwort WHERE thread='$id' ORDER by posttime ASC LIMIT $start,$stop";
                            $erga = mysql_db_query("700fps_d",$antworten,$verbindung);
                            while (list($aid,$threadid,$auser,$atext,$adatum,$azeit,$posttime) = mysql_fetch_row($erga))
                            {
                                $whileuserabfrage = "SELECT isAllowed,posts,signatur,avatar,regdate,lastaction,session_id,isMod,isAdmin,isPayuser FROM Users WHERE name='$auser'";
                                $ergwhile = mysql_db_query("700fps_d",$whileuserabfrage,$verbindung);
                                list($a_isallowed,$a_posts,$a_signatur,$a_avatar,$a_regdate,$a_lastaction,$a_session_id,$a_isMod,$a_isAdmin,$a_isPayuser)= mysql_fetch_row($ergwhile);

$sql = "SELECT id FROM verwarnungen WHERE user='$auser'";

Allein DAS geht schon in EINER Abfrage ... informiere dich mal über JOINs!

MfG,
EKKi