Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 13 Jun 2007, 18:54
gabrielt gabrielt is offline
Join Date: Apr 2007
Last 10 Threads


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?

Reply With Quote
Old 14 Jun 2007, 08:52
Dismounted's Avatar
Dismounted Dismounted is offline
Join Date: Jun 2005
Real name: Hanson
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.
Former Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote

Similar Threads
Thread Thread Starter Forum Replies Last Post
ViewPosts -- View unanswered threads, threads you've started, you're own posts etc. Jordeh vBulletin 3.0 Full Releases 19 12 Mar 2009 22:07
Tagged Threads: Subscribed Threads behave like Sticky Threads Chris M vBulletin 3.5 Add-ons 35 28 Mar 2008 17:57

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 06:47.

Layout Options | Width: Wide Color: