Slow phorum

This is a reply from my host provider, please, could anybody help me on this?

Thanks.

................................................................................................
It is still getting stuck in the place it was before. This is from
mysqladmin proc
| 355 | root | localhost | foros | Query | 71 |
Copying to tmp table | SELECT thread, modifystamp, count(id) AS tcount,
FROM_UNIXTIME(modifystamp) AS latest, max(id) as ma |

That query needs to be optimized in some fashion. I'm hesitent to try and
hunt through your forum source code to find the location myself, since
that could take a long time. Can you see if the author has any
suggestions? You're getting 100% of the CPU time on this system, and
using up 600-800MB RAM, just with a bunch these queries

reply to *what*?
you are not telling any specs like about how many messages/forums we are talking here, which phorum-version and similar.

3.4.8a is the version and I the software is holding about 300,000 mesages.

Thanks

Pepe

in one forum or in multiple forums?
what mysql-version do you run it on?

Same problem here.

* Multiple forums
* MySQL 4.0.20a-nt
* W2k

DB are between 50 - 100 MB....

HELP PLEASE....