Can this be done without huge amount of queries

[aceofspades]

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

[MoT3rror]

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

[MagnetiCat]

Originally Posted by MoT3rror

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.

[MoT3rror]

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.

[MagnetiCat]

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.

[aceofspades]

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?

[MoT3rror]

Originally Posted by aceofspades

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.

[Dismounted]

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

[MoT3rror]

Originally Posted by Dismounted

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