postmaster 데몬이 갑자기 많이 뜨고 죽지 않으며 속도가 무지하게 느려졌습니다. 다음 소스를 분석해주시면 고맙겠습니다.

function getArticlesFromLocation($locationNum, $sizeNum, $db) {

global $DBConn, $db;

$sqlStmt = " DECLARE mycursor CURSOR FOR ";

$sqlStmt = " $sqlStmt SELECT * FROM articles WHERE location=$locationNum Order by dateregistered DESC ";

pg_exec($DBConn, $sqlStmt);

$sqlStmt = " SELECT articles.dateregistered as intdate, articles.*, articles.photo AS photo, categories.id AS categoryid , categories.description AS category FROM softlinks, categories, articles where categories.id = softlinks.categoryid AND articles.id = softlinks.articleid AND articles.location = $locationNum Order by dateregistered DESC ";

$resultSet = pg_exec($DBConn, $sqlStmt);

$resultSize = pg_numrows($resultSet);

for ($i = 0 ; $i < $sizeNum && $i < $resultSize ; $i++) {

$row = pg_fetch_object($resultSet, $i);

$Title = $row->title;

$Content = han_substr($row->content,145);

echo "&nbsp;<img src='images/contents_trispot.gif'>&nbsp;<font style='font-size:9pt'>

<a href='../userview/u_articleview.php3?db=$db&id=$row->id&page=$page&depth=$row->categorydepth&cid=$row->categoryid&sid=$cid&addenURL' taget=_self>

<b>",$Title ,"</b></a></font><br><img src=../images/blankline.gif><br>&nbsp;&nbsp;<table border=0><tr><td width=15></td><td><font style='font-size:9pt;' style='line-height:175%;' color=#133C3F>",$Content,"</font></td></tr><tr><td height=3></td></tr> </table>";

}

$sqlStmt = "CLOSE mycursor";

pg_exec($DBConn, $sqlStmt);

}