[PHP-DB] Performance problems?

[Leif K-Brooks]

I've been optimizing scripts in an attempt to speed my friend's site up, and I believe I've found the source of the performance problems. When I comment the following page load time changes from around 6 seconds to less than .5 of a second.

if($loggedin){
$events = mysql_query("select * from events where whofor='{$userinfo['id']}' order by id desc limit 1");
if(mysql_num_rows($events) == 1){
$events = mysql_fetch_array($events);
print <<< END
<p align="center"><a href="{$basepath}doevent.php?id={$events['id']}">{$events['message']}</a></p>
END;
}
}

This code checks for events (new mail, etc.) that the user may have and dispays them. Any idea on what makes it perform this badly?
--

The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php