Congratulations Ian!

Anything not related to a specific project.

Congratulations Ian!

Postby Sleepwalker3 » Thu Dec 20, 2012 2:10 am

Congratulations Ian on reaching a milestone 10,000 Posts! 7.92 posts per day an over 21% of all posts ! - Wow! I'm sure I speak for everybody here when I say thanks to you and the rest of the DP crew, this is a great site and certainly my fav for this sort of thing.
Here's to the next 10,000 . . .if your keyboard doesn't give up beforehand!
User avatar
Sleepwalker3
Hero Member
Hero Member
 
Posts: 539
Joined: Mon Jan 16, 2012 4:12 am
Location: Down Under

Re: Congratulations Ian!

Postby ian » Thu Dec 20, 2012 2:27 am

Thanks so much, I'm glad you like it here.

I did have a hunch I was quite close to 10K. Usually Sjaak warns me in the workshop :)
User avatar
ian
Crew
Crew
 
Posts: 10578
Joined: Mon Jul 06, 2009 6:14 am

Re: Congratulations Ian!

Postby vimark » Thu Dec 20, 2012 2:31 am

Happy 10,000th post Ian
vimark
Crew
Crew
 
Posts: 1294
Joined: Fri Feb 12, 2010 3:23 am
Location: Davao City, Philippines

Re: Congratulations Ian!

Postby Sjaak » Thu Dec 20, 2012 6:39 am

ian wrote:Thanks so much, I'm glad you like it here.

I did have a hunch I was quite close to 10K. Usually Sjaak warns me in the workshop :)



Sorry man, i was sleeping :(
User avatar
Sjaak
Fellow
Fellow
 
Posts: 3039
Joined: Sun Jan 03, 2010 2:45 pm
Location: Hiero

Re: Congratulations Ian!

Postby bearmos » Thu Dec 20, 2012 7:40 am

that's a lot of posts! so is there something interesting between 10,000 and 0x10000. . .maybe 21,845 (0x5555 for the testing crowd) :)
bearmos
Hero Member
Hero Member
 
Posts: 741
Joined: Tue Nov 02, 2010 10:02 pm

Re: Congratulations Ian!

Postby hak8or » Fri Dec 21, 2012 6:02 pm

Out of curiosity, how much space is being occupied by all these posts? I am guessing maybe 5 Gigabytes at most?

Also, congratulations! :)
hak8or
Full Member
Full Member
 
Posts: 239
Joined: Mon Jun 06, 2011 11:06 pm

Re: Congratulations Ian!

Postby dolabra » Fri Dec 21, 2012 7:56 pm

My guess would be less. I bet its more in the 5MB range. 5GB would be 50K per post! Ian has a lot to say, but not that much!
dolabra
Full Member
Full Member
 
Posts: 236
Joined: Tue Sep 06, 2011 6:45 pm

Re: Congratulations Ian!

Postby ian » Sat Dec 22, 2012 12:51 pm

I checked the admin panel, did not SSH into server and check MYSQL so these are 'rough' sizes:


Database size: 177.41 MiB
Number of posts: 46246
Number of topics: 4406
Size of posted attachments: 1.24 GiB
Number of attachments: 7557
Board started: Tue Jan 25, 2011 9:18 am <<remember we were Simple Machines Forum for years before PHPBB3, though all old posts and attachments were migrated to the new forum.
User avatar
ian
Crew
Crew
 
Posts: 10578
Joined: Mon Jul 06, 2009 6:14 am

Re: Congratulations Ian!

Postby dolabra » Sat Dec 22, 2012 5:19 pm

4k per post --- that's a bit more than I thought. Interesting stats. Thanks.
dolabra
Full Member
Full Member
 
Posts: 236
Joined: Tue Sep 06, 2011 6:45 pm

Re: Congratulations Ian!

Postby sqkybeaver » Sat Dec 22, 2012 6:17 pm

dolabra wrote:4k per post --- that's a bit more than I thought. Interesting stats. Thanks.


I write programs smaller than that! iirc a basic word document has about a min size of 4k
User avatar
sqkybeaver
Hero Member
Hero Member
 
Posts: 1095
Joined: Tue Dec 07, 2010 8:50 am
Location: New Hampshire, USA

Re: Congratulations Ian!

Postby matseng » Sat Dec 22, 2012 9:56 pm

The indexes for freetext searching frequently takes up more space than the text themselves.
User avatar
matseng
Hero Member
Hero Member
 
Posts: 876
Joined: Sat Oct 15, 2011 12:29 pm
Location: Kuala Lumpur, Malaysia

Re: Congratulations Ian!

Postby ian » Tue Dec 25, 2012 4:51 am

The indexes for freetext searching frequently takes up more space than the text themselves.


Bingo! It is indeed the indexes that show the biggest bloat. I can dump full table metadata for forum, wiki, and store and post if anyone is interested.
User avatar
ian
Crew
Crew
 
Posts: 10578
Joined: Mon Jul 06, 2009 6:14 am

Re: Congratulations Ian!

Postby arhi » Thu Dec 27, 2012 7:51 pm

I have not plaid with phpbb3 for a while but iirc you can turn off phpbb indexing and let it use mysql's text search. donno what's faster (I was always running the phpbb's index as disk space was really never an issue) ... on the other hand I see many phpbb disabling internal phpbb's search completely and adding just a "search via google" option to the site as search kills the performance quickly (on high traffic sites) so off loading that to google makes sense :)
User avatar
arhi
Hero Member
Hero Member
 
Posts: 2109
Joined: Thu Jun 24, 2010 11:41 am
Location: Belgrade, Serbia


Return to General discussion