RE: Adding attributes (in a massive way)....

["Howard Chu" <hyc@highlandsun.com>]

> -----Original Message-----
> From: owner-openldap-software@OpenLDAP.org
> [mailto:owner-openldap-software@OpenLDAP.org]On Behalf Of Peter Marschall

> Hi,
>
> On Wednesday 19 March 2003 14:57, Frank Swasey wrote:
> > On my servers (IBM x330's with dual 1.2GHz Pentium III processors
> > running Red Hat Linux 7.3 and Openldap 2.0.27), I am able
> to slapcat my
> > almost 54000 entry database in about 18 seconds.  The slapadd takes
> > about 4m30s.  An ldapmodify hitting all 54000 entries would
> take about
> > 15 hours.
>
> I cannot believe tthe numbers for the ldapmodify.
> Did you actually measure them ?
>
> I just tested the modification of the description attribute on 20.000
> inetorgPerson objects (with about 25 attributes each) on an
> 800MHz AMD Duron with 512 MB RAM:
> It took not more than 12 min and 30 sec.
>
> The update was done using a Perl script based on Net::LDAP,
> slapd and the client script were running on the same host.
> During the update the system was running the KDE GUI and
> was used for web browsing and a few ldap searches on exactly
> the same LDBM backend (I wanted to know how fast the update
> worked before it ended ;-),
>
> And no, the description attribute is not indexed.

Updating a non-indexed attribute will be quicker than indexed, since no index
needs to be updated then.

You two may be measuring very different scenarios; using the commandline
ldapmodify with one modification per invocation will of course be slower than
feeding a large LDIF to a single invocation, due to connection management
overhead. If your Perl script wrote all the mods through one connection, as
opposed to a single connection per mod, then it would also be quicker than
otherwise.

  -- Howard Chu
  Chief Architect, Symas Corp.       Director, Highland Sun
  http://www.symas.com               http://highlandsun.com/hyc
  Symas: Premier OpenSource Development and Support