[Gio~Logist]

Originally Posted by magicfox

Hi there!

I want to use the "PluhNews" news grabber for a updated version of my general homepage to include the latest 8 threads from my vBulletin 2.3.0 forum directly on the main page, but I'm afraid the resulting server load could be too big, when "PluhNews" performs the collection of the latest threads.

"PluhNews" uses the following SQL query to grab the latest entries from the database:

SELECT threadid, title, forumid, replycount, postusername, postuserid, lastposter, dateline, iconid FROM thread WHERE forumid IN ("8,9,10,11,12,13,14,15,16,17,18,24,33") ORDER BY threadid DESC LIMIT 8

8,9,10 and so on are the forums which should be "scanned".

So each time a user calls my homepage, this query will be started. My forum is pretty big (~35.000 postings each month, ~300 users at once online, whole database ~700 MB) and I'm not sure if the server could stand this query.

Since I'm not familiar with SQL at all my questions:

- Do you think this query could cause problems or is the query not server intensive at all?
- Is there a way to change to query for a lower impact on the server?

Thanks a lot!

That query seems fine to me and does not look as if it would take a long time to generate.