Last 10 Threads

[gabrielt]

Hi,

I am trying to pull the last 10 posts made on our forums, I am using the following query:

SELECT threadid, title, lastposter, replycount, views FROM thread WHERE visible <> 0 AND open <> '10' AND forumid NOT IN ('34','86','91','177','178') ORDER BY lastpost DESC LIMIT 10;

The problem is that this query takes 5 seconds to run and during it the CPU load goes to the roof.

Any advice or ideas on how to improve this? Maybe vBulletin has a cache of the last posts somewhere?

Cheers,
Gabriel.

[Dismounted]

That's not a very advanced or complicated query, many vBulletin queries are more complicated than that. If vBulletin is running fine, that query should run fine as well.