Delayed Points Stat

Rusting In Peace

Distinguished
Jul 2, 2009
1,048
0
19,460
I'm curious why when posting the points on the right hand profile box aren't updated immediately on refresh.

Presumably when a post is made the database is updated appropriately but seemingly the points are derived when generating the html response rather than using a stored value?

Or perhaps you have a trigger or some other process that goes away and updates points for all users at given intervals?

It's not a problem at all I'm just interested in the behavior!
 
Solution
I'm just guessing - but it's possible the database is cached and you're seeing the html page posting with some cached data.

Rusting In Peace

Distinguished
Jul 2, 2009
1,048
0
19,460
Caching is also feasible. But I would have expected the cache to be blown away when a post was made. I.e. don't bother retrieving user details from the database when they are just browsing the forums. Guess it depends on the schema!