http://bbpress.org/forums/ bbPress Support Forums Tag: numbers en Fri, 09 Jan 2009 03:43:45 +0000 http://bbpress.org/forums/topic/pre-installation-spam-and-user-numbers#post-13341 Thu, 24 Jan 2008 08:38:34 +0000 finalwebsites 13341@http://bbpress.org/forums/ <p>Hi Trent, thanks for the feedback!</p> <p>just checked the suggested plugin and using some activation code makes sense. Is this something for the bbress core version? And is this really needed? At the moment I have ~50 new registrations a day because people need to register to download some PHP classes from my website.</p> <p>Sure some of them have entered their URL to the profile, but this is not accessible until thy made a first post. </p> http://bbpress.org/forums/topic/pre-installation-spam-and-user-numbers#post-13340 Thu, 24 Jan 2008 05:59:27 +0000 cregy 13340@http://bbpress.org/forums/ <p>Thanks for all the feedback. Very helpful. </p> http://bbpress.org/forums/topic/pre-installation-spam-and-user-numbers#post-13325 Wed, 23 Jan 2008 07:37:13 +0000 chrishajer 13325@http://bbpress.org/forums/ <p>As an experiment, I created 1000 users automatically with long text for the username, website, interests, email, etc. I also inserted meta info for them (so, 1000 new user rows, 4000 new meta rows.) I checked the size of the Data_length and Index_length in MySQL.</p> <p>With 5 users, I had this:<br /> bbpress_users Data_length: 524 bytes<br /> bbpress_users Index_length: 3072 bytes<br /> bbpress_usermeta Data_length: 708 bytes<br /> bbpress_usermeta Index_length: 5120 bytes</p> <p>With 1005 users, I had this:<br /> bbpress_users Data_length: 384,524 bytes<br /> bbpress_users Index_length: 142,336 bytes<br /> bbpress_usermeta Data_length: 280,708 bytes<br /> bbpress_usermeta Index_length: 146,432 bytes</p> <p>So, 1000 additional fake user registrations used about 1MB of disk space. In reality, the data I used for the fake registrations is far longer than any spam registration I've ever gotten. In fact, the average row length for bbpress_users went from 107 bytes to 382 bytes since the fake data I used was so ridiculously long. The bbpress_usermeta didn't go up as much: from an average row length of 52 bytes to 69 bytes.</p> <p>Bottom line: 1000 spam registrations, if they actually did occur, would not hurt anything at all. To prevent those registrations in the first place though, I would use Akismet and the "enhanced registration" plugin. Then you don't need to worry about the registrations at all. </p> http://bbpress.org/forums/topic/pre-installation-spam-and-user-numbers#post-13314 Tue, 22 Jan 2008 21:15:57 +0000 Trent 13314@http://bbpress.org/forums/ <p>The spam post isn't under moderation, but spam posts that are well written in WP are not either as they display immediately. I can tell you this though, on wordpress.com support forums there are very few "spambot" posts that make it past akismet. I have a couple small forums myself, but I have never had a post get past akismet except posts that don't have any bad words or links which really "could be" real user posts. Even that number is pretty low. I have more problems with spam registrations, but livibetter's "enhanced registration" plugin took care of that :)</p> <p>Trent </p> http://bbpress.org/forums/topic/pre-installation-spam-and-user-numbers#post-13312 Tue, 22 Jan 2008 20:57:14 +0000 finalwebsites 13312@http://bbpress.org/forums/ <p>Because we are talking about spam and bbpress, at the moment I don't have problems with spam (I guess the spammers didn't about my forum)</p> <p>how is the spam protection works it the same way as in WP? In WP akismet is filtering more than 99% of the spam. </p> <p>Here in bbpress it's different: a well written spam post is not "under moderation" </p> http://bbpress.org/forums/topic/pre-installation-spam-and-user-numbers#post-13305 Tue, 22 Jan 2008 19:14:11 +0000 Trent 13305@http://bbpress.org/forums/ <p>Any guess on how much space say 100,000 users (spam and real) would take in actual database space? If it is a small amount, then why even worry about deleting them :)</p> <p>Trent </p> http://bbpress.org/forums/topic/pre-installation-spam-and-user-numbers#post-13303 Tue, 22 Jan 2008 18:50:16 +0000 sambauers 13303@http://bbpress.org/forums/ <p>That's right, enough room for every person on the planet to have 3 billion accounts in your installation. </p> http://bbpress.org/forums/topic/pre-installation-spam-and-user-numbers#post-13300 Tue, 22 Jan 2008 14:33:41 +0000 chrishajer 13300@http://bbpress.org/forums/ <p>The bb_users table uses an unsigned bigint for the user ID which allows numbers up to 18,446,744,073,709,551,615. How many people are there in the world?</p> <p><a href="http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html#id4784709" rel="nofollow">http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html#id4784709</a></p> <p>You would have more of an issue with hardware and bandwidth than you would with any kind of limit that is built into the software. </p> http://bbpress.org/forums/topic/pre-installation-spam-and-user-numbers#post-13297 Tue, 22 Jan 2008 10:15:15 +0000 finalwebsites 13297@http://bbpress.org/forums/ <p>I have more than 1000 registrations now, I'm not sure what happens if some but will start to register fake accounts. If this becomes a problem you need to something else.</p> <p>bbpress works with akismet and this works fine on wordpress </p> http://bbpress.org/forums/topic/pre-installation-spam-and-user-numbers#post-13294 Tue, 22 Jan 2008 07:03:44 +0000 cregy 13294@http://bbpress.org/forums/ <p>Hi All</p> <p>Could someone please tell me how well BBPress works in fending of spam registrations please? Is it a case of using every means possible or is there a flawless way of doing it?</p> <p>I am also wondering is there a user limit for BBPress. i.e. How many users would it support please? 100,000 - 1,000,000 or more?</p> <p>I have a client that has been told that she will get a 1,000 spam registrations a day and that open source software cannot support more than a few thousand users. I want to direct her to this post. So hopefully we can encourage her.</p> <p>Many thanks</p> <p>Rich </p>