Performance problems?
| From: | Leif K-Brooks | Date: | Sat, 02 Nov 2002 06:21:09 +0000 |
| Subject: | Performance problems? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22907@lists.php.net to get a copy of this message | ||
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.