on 1/10/01 5:07 AM, Stephen Samuel at [EMAIL PROTECTED] wrote:
> Well, even if that was only for the last 1000 users, 8000 minutes
> would come to 5.5 days to do the insertion ( `units 8000minute day`).
> My guess, from the sounds of this, is that after ~50K users, insertion
> starts to get increasingly expensive and lengthy. To an impatient user,
> even a few seconds delay might seem like vadduser had permanently
> blocked.
>
> I.e. you may be closer to recreating the problem than you think. It
> looks like an increasing delay after
I was alluding to the Maildir not being created for users above 51388.
That's the problem that I couldn't recreate.
As it's known that cdb is more efficient than SQL for lookups, it's also
known to be significantly slower with inserts/updates for sites with 10,000
plus users. In my test with cdb, I added all the users with the -s option
to not update the cdb file. Then used vmkpwasswd to create it. THAT took 8
minutes, as did subsequent vadduser commands without the -s option.
Incidentally, how people using cdb for sites with 50,000+ users handle
updates? Especially for free email services? It would seem odd to signup,
then have to wait to log in? (Although it wouldn't be 8 minutes on a more
suitable machine than my test box).
Cheers,
Bill Shupp
