Thread Recap (last 10 posts from newest to oldest)
Mar 18, 10 at 4:52pm
tekmosis
If you don't have a proper cleanup routine to clear out that table, it can get pretty big depending on how many forums+users you have.
Mar 16, 10 at 2:35pm
Tom
I suppose that could work. It's just that if I have hundreds of forums and thousands of users it's a lot of activity to monitor and I wasn't sure if that was the most efficient way of going about it. But thanks, I'll do it like that.
Mar 15, 10 at 11:55pm
Artificer
Well since what you want to store is "User is last active in Forum at Time," then a simple approach would be to have a table ForumActivity that has three columns—UserId, ForumId, and LastActiveTime. The primary key would be UserId and ForumId.
Not sure if this is what you're asking for though, or if you're looking for something else.
Mar 10, 10 at 6:09pm
Tom
Ok, so in my software, if a user is permitted to see the online status of another, then they will be shown as online if their account has been active in the last 15 minutes, and offline if it has not, and to make a list of people active on the site is easy enough... Just run a query to get every account which has had activity in the last 15 minutes.
But, when I want to go about saying who is active in a given forum, how would I go about that efficiently, bearing in mind that they can be active in multiple forums at any one time?
Powered by neoforums v1.6.5b (aperture) Copyright Neo Era Media, Inc. 1999-2013
