[Wideawake]

Ok anyone wanna help with this one. Im no php expert nor do I know whats going on here but I just recieved a letter from our host complaining about our db. Heres the letter, if anyone can help please drop ur suggestions here!
Thanks,
Mike

Hello,


This query is running on your ppcgeeks database and causing high server
loads. It needs to be fixed soon because it is causing slowness and high
loads, if it isn't and causes further issues I will need to disable the
database. If you have further questions you can write me at
xx@dreamhost.com. If the query can't be optimized, then sorry but
the database is too inefficient for shared hosting, and you will need to
look at a VPS or dedicated solution:


http://dreamhost.com/dedicated-hosting.html


# User@Host: user[user] @ geyser.dreamhost.com [208.97.183.12]

# Query_time: 93 Lock_time: 0 Rows_sent: 15 Rows_examined: 267055

SELECT f.forum_name, t.topic_title, u.user_id, u.username, u.user_sig,
u.user_sig_bbcode_uid, p.post_id, pt.post_te

xt, pt.post_subject, pt.bbcode_uid, p.post_time, t.topic_replies,
t.topic_first_post_id

FROM phpbb_forums AS f, phpbb_topics AS t, phpbb_users AS u,
phpbb_posts AS p, phpbb_posts_text as pt

WHERE

t.forum_id = f.forum_id

AND f.auth_view = 0

AND p.poster_id = u.user_id

AND pt.post_id = p.post_id

AND p.topic_id = t.topic_id



ORDER BY p.post_time DESC LIMIT 15;


Thanks!

Justin