묻고답하기

db 에서 가져오는 건 잘돼는거 확인 했는데 퍼포먼스가 느려서 그런지 중간에 자꾸 끈기네요... 조언좀 부탁합니다.

$result = mysql_fetch_array(mysql_query ("select count(*) from mailling order by numb"));
$totalnum = $result[0]; //회원전체수

if(!$sendnum) $sendnum = 100;
$startnum = 0;



$j = $totalnum / $sendnum + 1;

for($i=0; $i <= $j; $i++) //$sendnum 만큼 짤라서 매일보내기
                        {
        
                                
                $startnum = (100*$i);

                $ma=mysql_query("select userid,username,email from mailling order by numb desc limit $startnum, $sendnum") or die("메일을 보낼수 없습니다.");

                      while($data=mysql_fetch_array($ma))
                                                  {
                             $uid = $data[userid];
                         $name = $data[username];
                             $email = $data[email];
                    
                        
                            
                              mail($email, $mailsubject, $body, $header) or die("메일을 보낼수 없습니다.");
                           }
    
        
                        
                        }