Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 13 Jun 2007, 17:54
gabrielt gabrielt is offline
 
Join Date: Apr 2007
Last 10 Threads

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.
Reply With Quote
  #2  
Old 14 Jun 2007, 07: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 vBulletin.org 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
Reply

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 21:07
Tagged Threads: Subscribed Threads behave like Sticky Threads Chris M vBulletin 3.5 Add-ons 35 28 Mar 2008 16: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 09:04.

Layout Options | Width: Wide Color: