UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support General MySQL question

There are a number of slow query logs for your database, but they are all pretty much identical to what Phil posted. The last one is:

User@Host: gbb_admin[gbb_admin] @ localhost []
# Query_time: 12 Lock_time: 0 Rows_sent: 1 Rows_examined: 131650
select COUNT(*) as posts,
sum(t1.POST_IS_TOPIC) as topics
from ubbt_POSTS as t1,
ubbt_TOPICS as t2
where t2.FORUM_ID = 5
and t1.TOPIC_ID = t2.TOPIC_ID
and t1.POST_IS_APPROVED = '1'
and t1.POST_POSTED_TIME > 1172184193;

We don't have anything aside from those queries that are showing fairly slow.