Can this be done without huge amount of queries
 

Is it possible to gather lots of information about what has recently happened on the forum without using a query each time?

For example:

Recent Posts
Recent logins
Birthdays
Recent PM's
Recent friend adds

etc

Am i right to be looking for a query alternative or is it actually the best way of getting this information? Im trying to save server load and speed up loading times.

Thank you :)

James

You can try to use the vBulletin datamanager to cache the info but then the data could not be as accurate.
https://vborg.vbsupport.ru/showthrea...ht=datamanager

Yeah, the only way to go. Even if you run a cronjob very often - every minute - you are still getting much less queries than what you would get in a website with dozens of visitors at the same time.

Well you don't have to do a cron job. It might just be best to update the datamanager every time the data is updated.

In my opinion, still not a good choice in a popular forum. In that case, that would run updates still too often; at least in forums where there are 200+ users working at the same time. Of course, it depends on query complexity and forum traffic. If you have little traffic, an update at each change would be more than enough.

I appreciate the help. Initially there wont be many users but i am hoping to get +200 at once in the future. Does anyone know how facebook does it?

They must suffer from a similar problem, and yet they are still able to update the forum with thousands of users online at once?

Well they probably have more then 25 servers and probably a ton of memory cache servers powering their system.

25 servers only? You've got to be kidding me. It's more like an entire datacentre with dedicated gigabit links.

It was just a guess, I just know it would take a ton of servers:rolleyes: