[Ghostt]

this "sorting result" query.
why no one can explain why this query often slow and apear all the time?

| Query | 1 | Sorting result | SELECT thread.threadid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount |

-i found this line in /tags.php

-ive set to update thread views every 20 min with cron.
sometimes this cron get timeout error tested to run manuelly .

also i used googled very long and dont find any result.

i think everytime this task crashes it created a temp table...
and this all also the query are connected.