Is database updated each time new user views particular thread? Seems like it could put a lot of additional load on database even though the content of the thread is not updated.
I was thinking maybe forum application keeps counter in memory and only updates database when the number of views is divisible by 10 or something like that, basically not for each new view but only for each n-th new view. After all if server crashes and
view counter is off by some number it doesn't really matter.
Or maybe I am overestimating the database load if counter is updated for each new view.
Go to the complete details ...