[wp-hackers] Maximum # of users

Dr. Mike Wendell theapparatus at gmail.com
Sat Feb 3 17:50:49 GMT 2007


Gotta remember spammer accounts as well though.  I made my main blog
Account required for Comment posting and get about a hundred new
account generated every day. :(

-drmike

On 2/3/07, Robin Adrianse <shorty114 at shorty114.net> wrote:
> ID's aren't reused. They're AUTO_INCREMENT, which means that once an ID is
> used, it skips ahead. That's why post ID's and etc jump all around if you
> delete a post, etc.
>
> If the 2 billion mark is really a problem, you may be able to switch some
> stuff in the database around (column types). But 2 billion is about 1/3 of
> the world's population... I don't think WP.com is even going to hit that
> very soon. Keep in mind that # of blogs != # of users. A lot of users have
> more than one blog attached to their username.
>
> On 2/2/07, Angsuman Chakraborty <angsuman at taragana.com> wrote:
> >
> > > I  really don't think 2 billion is anything we need to worry about for
> > now.
> >
> > I heard that before in an enterprise software startup I was part of (it
> > was
> > successful and is now part of GE in case you are interested). We hit the 2
> > billion mark way sooner than expected because id's were being allocated in
> > batches (similiar to ip address problem) and lots of unused id's were left
> > in the middle. Anyway the point I am trying to drive home is that
> > wordpress.com, rather than any individual blog, may reach the limit
> > reasonably soon. Also I don't know if id's are reused, I don't think it
> > is.
> >
> > My two cents...
> > Angsuman
> > http://blog.taragana.com/
> > -----Original Message-----
> > From: wp-hackers-bounces at lists.automattic.com
> > [mailto:wp-hackers-bounces at lists.automattic.com]On Behalf Of Mark
> > Jaquith
> > Sent: Wednesday, January 31, 2007 8:44 AM
> > To: wp-hackers at lists.automattic.com
> > Subject: Re: [wp-hackers] Maximum # of users
> > Importance: Low
> >
> >
> > On Jan 30, 2007, at 6:54 PM, Charles Hooper wrote:
> >
> > > What's the maximum number of users Wordpress intends to support?
> > > User IDs in wp_users are stored as BIGINT(20), however while
> > > messing about with the caching functions I noticed that get_userdata
> > > () casts the supplied ID to an integer, making ~2 billion the
> > > maximum number of users possible that Wordpress can handle.
> >
> > WordPress 2.0.x can't handle much more than 800-1000 users because of
> > the way wp-admin/users.php loads them all onto the same page (you run
> > out of memory at this point).  2.1 fixes that and it can scale to at
> > least 10,000, but I honestly have no idea what the ceiling is now.  I
> > really don't think 2 billion is anything we need to worry about for now.
> >
> > --
> > Mark Jaquith
> > http://markjaquith.com/
> >
> > Covered Web Services
> > http://covered.be/
> >
> >
> > _______________________________________________
> > wp-hackers mailing list
> > wp-hackers at lists.automattic.com
> > http://lists.automattic.com/mailman/listinfo/wp-hackers
> >
> > _______________________________________________
> > wp-hackers mailing list
> > wp-hackers at lists.automattic.com
> > http://lists.automattic.com/mailman/listinfo/wp-hackers
> >
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>


-- 
Blog: http://tdjc.be
Kim Possible: Remixed: http://kpremixed.tdjc.be
Get your own free hosted WordPress Blog today: http://daria.be


More information about the wp-hackers mailing list