PDA

View Full Version : Can this be done without huge amount of queries

aceofspades
05-10-2008, 03:04 PM
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
05-10-2008, 05:15 PM
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/showthread.php?t=119376&highlight=datamanager
MagnetiCat
05-10-2008, 07:37 PM
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/showthread.php?t=119376&highlight=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
05-10-2008, 08:54 PM
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
05-11-2008, 02:57 AM
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
05-12-2008, 11:47 AM
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
05-12-2008, 04:01 PM
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
05-13-2008, 07:18 AM
25 servers only? You've got to be kidding me. It's more like an entire datacentre with dedicated gigabit links.
MoT3rror
05-13-2008, 01:02 PM
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: