RE: [PHP-DB] Performance problems?
| From: | John W. Holmes | Date: | Sat, 02 Nov 2002 12:33:16 +0000 |
| Subject: | RE: [PHP-DB] Performance problems? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22913@lists.php.net to get a copy of this message | ||
What's the structure of your database table? Whofor and id should have
indexes on them to speed up queries like this.
---John Holmes...
> -----Original Message-----
> From: Leif K-Brooks [mailto:eurleif@buyer-brokerage.com]
> Sent: Saturday, November 02, 2002 1:21 AM
> To: php-db@lists.php.net
> Subject: [PHP-DB] Performance problems?
>
> 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