Quote:
Originally Posted by Booyeh
Is it possible to do stats for 2009 alone? Top 100 will probably look pretty different.
|
while all the posts are in the post table, searching that would be a total *****. the posts table is huge. So tend to avoid touching that.
Best way would be to take a snap shot of the user table at the start of the year and then compare at the end. it keeps a post count in it see. to save querying the post table.