Where are we posting?

It would be cool if we could see (in the UserCP or public profile) where we are posting...

For example out of my 1000 posts, how many are in the lounge, in the php forum, etc... bar graph or % would be great...

Also, how many threads you've started might be kinda cool as well (add the number of started threads to the link in the public profile...)...

I agree it'd be cool, but probably quite complex to add into vbulletin (unless a hack already exists... I'll search in a moment).

About the number of threads started, it is possible to search from the public profile page for threads started by a user (eg for you here), but obviously this number doesn't appear on your profile and you have to do it manually.

Yeah, I imagine it would be pretty complex... even just the top 3-5 would be great... and as far as the threads started, that seems like it may be kinda easy since that link takes you to the threads that were started, all that would need to be done is a COUNT on those records... though that may add more overhead than acceptable to the first public profile page...

We create a hack for this one, but we notice the complex queries associated with this one are highly resource intensive and put too much load on our database servers. Especially for those users who have high number of posts. We notice very high load for users who have high number of posts.

Could you do the database query once, and store the resulting stats somewhere, and update it after each post? That would replace the need to do a huge database query each and every time the data is requested.

or maybe, update the stats once a month (or bi-monthly) ?

The sql query we have to use for this one is very nasty one, it is going to put lot of load on our DB servers. We have currently about 158,779 members in this forum. Creating a stat table for each member also going to put lot of loads in our servers and if we are going to do that way we need to find a time frame for this resource intensive task. We cannot run this kind of high resource intensive task in a high traffic hours. All the ideas are welcome, we will look forward to find more appropriate way to do this hack.

Holy crap!

I see what you mean. Even doing one user per minute would take 110 days to complete. That's even assuming every user, including Sep, will take less than a minute to complete.

I wouldn't care about the wait though.

Why not just do it once people have reached a certain number of posts (say 100 to match the full user rule), this should heavily chop down the number of users you need to process?

Also, it doesn't really need to be updated in real time does it? So you could cache the results weekly or something.

Finally, why not do the original calculation in parts ie: all users starting with A on monday night at 4am, all users starting with B on tuesday night (or userid #00001 -> 10000) etc?

--Simon

On DevShed alone, after going through the user list, I've found that 124,868 users have less than 100 posts. That's ~4162.5 pages out of 4205 pages, with 30 users per page. That's almost 99% of users!

Everybody loves meaningless statistics... Ok, here's one I'd be very much interested in:

The Troll Factor
A per-user "postcount in the lounge" divided by "postcount in all other forums"

Hey, since being a troll doesn't seem to be an insult anymore, you could maybe make something like the belts for troll factor...

M.