Post Count
- ATNO/TW
- Super Moderator
- Joined: May 28, 2003
- Posts: 23404
- Loc: Woodbridge VA
- Status: Offline
May 8th, 2006, 6:58 pm
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
- Anonymous
- Bot
- Joined: 25 Feb 2008
- Posts: ?
- Loc: Ozzuland
- Status: Online
May 8th, 2006, 6:58 pm
- WoRd Of WiSdOm
- Proficient
- Joined: May 23, 2004
- Posts: 284
- Loc: Riverside,California
- Status: Offline
May 11th, 2006, 1:43 am
- SpooF
- ٩๏̯͡๏۶
- Joined: May 22, 2004
- Posts: 3415
- Loc: Richland, WA
- Status: Offline
May 11th, 2006, 8:45 am
I always thought that the phpBB post count was just a added when the users posts. But now I can see that the board goes and looks at all the posts and then finds who posts them. This forum must take a nice server to run it. Every time you open a page the script looks through 309370 entrys... wow 309371 now 
#define NULL (::rand() % 2)
- suzie
- Guru
- Joined: Feb 07, 2004
- Posts: 1127
- Loc: England
- Status: Offline
May 11th, 2006, 9:08 am
Quote:
that'll teach you for posting crap!... just like me
Heheheheheheehe
- ATNO/TW
- Super Moderator
- Joined: May 28, 2003
- Posts: 23404
- Loc: Woodbridge VA
- Status: Offline
May 11th, 2006, 11:10 am
SpooF wrote:
I always thought that the phpBB post count was just a added when the users posts. But now I can see that the board goes and looks at all the posts and then finds who posts them. This forum must take a nice server to run it. Every time you open a page the script looks through 309370 entrys... wow 309371 now
No SpooF - much simpler than that. The users post count is stored in the phpbb_users table and incremented each time the user posts or decrimented each time a users post gets deleted.
So really, it's one "simple" query of the users table. (and I do believe Bigweb has a pretty nice server running it lol)
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
1, 2
To Reply to this topic you need to LOGIN or REGISTER. It is free.
Post Information
- Total Posts in this topic: 20 posts
- Users browsing this forum: No registered users and 13 guests
- You cannot post new topics in this forum
- You cannot reply to topics in this forum
- You cannot edit your posts in this forum
- You cannot delete your posts in this forum
- You cannot post attachments in this forum
