fuzmeister: I'm a Statistics FREAK
So I'm playing around with the Vent code - specifically this page. I'm trying to add some relevant statistics to the page... however, I've run into an issue with SQL.

If you clicked that link you will notice the page is SLOW. That's because to find the post with the most comments (for the "most active post" column), I have it going through every post and basically if the amount of comments returned with the corresponding post number is greater than what's currently stored in the variable, I replace the variable. There has got to be a better way.

Is anyone aware of a way using SQL to return the the fields with the most occurrences of a like value? That would mean one query in the comments to get the post number that has the most...

Mood: Statistical

Tags (beta): vent, development

Comments (7)