Re: why is adding records slow?

[Ricky Charlet <rcharlet@redcreek.com>]

Howdy,

	I made a cut and past error in the names of my tests. The sequece of
tests should be named First Second Third and Fourth, instead of First
Second Second and Second.



> 
> Test = add 10K records to an empty ldbm database through ldapadd.
> Measure time to completion.
> 
> slapd.conf for First run:
> -----------------------
> schemacheck on
> cachesize 100000
> dbcachesize 15000000
> dbnosync
> #dbcachenosync
> pidfile /var/run/slapd.pid
> argsfile        /var/run/slapd.args
> database        ldbm
> suffix          "dc=ricky, dc=com"
> rootdn          "cn=Manager, dc=ricky, dc=com"
> rootpw          "******"
> directory       /var/lib/ldap
> # Indices to maintain
> index   objectClass,uid,uidNumber,gidNumber     eq
> index   cn,mail,surname,givenname               eq,subinitial
> 
> time to add 10K records = 7692 seconds
> 
> ======================================================
> 
> slapd.conf for Second run: (turn off indexing)
> -----------------------
> schemacheck on
> cachesize 100000
> dbcachesize 15000000
> dbnosync
> #dbcachenosync
> pidfile /var/run/slapd.pid
> argsfile        /var/run/slapd.args
> database        ldbm
> suffix          "dc=ricky, dc=com"
> rootdn          "cn=Manager, dc=ricky, dc=com"
> rootpw          "******"
> directory       /var/lib/ldap
> # Indices to maintain                           eq
> #index  objectClass,uid,uidNumber,gidNumber     eq
> #index  cn,mail,surname,givenname               eq,subinitial
> 
> time to add 10K records = 2516 seconds
> 
> ======================================================
> 
> slapd.conf for Second run: (turn on dbcachenosync)
> -----------------------
> schemacheck on
> cachesize 100000
> dbcachesize 15000000
> dbnosync
> dbcachenosync
> pidfile /var/run/slapd.pid
> argsfile        /var/run/slapd.args
> database        ldbm
> suffix          "dc=ricky, dc=com"
> rootdn          "cn=Manager, dc=ricky, dc=com"
> rootpw          "******"
> directory       /var/lib/ldap
> # Indices to maintain                           eq
> #index  objectClass,uid,uidNumber,gidNumber     eq
> #index  cn,mail,surname,givenname               eq,subinitial
> 
> time to add 10K records = 1900 seconds
> 
> ======================================================
> 
> slapd.conf for Second run: (turn schemacheck to off)
> -----------------------
> schemacheck off
> cachesize 100000
> dbcachesize 15000000
> dbnosync
> dbcachenosync
> pidfile /var/run/slapd.pid
> argsfile        /var/run/slapd.args
> database        ldbm
> suffix          "dc=ricky, dc=com"
> rootdn          "cn=Manager, dc=ricky, dc=com"
> rootpw          "******"
> directory       /var/lib/ldap
> # Indices to maintain                           eq
> #index  objectClass,uid,uidNumber,gidNumber     eq
> #index  cn,mail,surname,givenname               eq,subinitial
> 
> time to add 10K records = 1900 seconds (no change from last test)
> 
> ======================================================
> 
> --
>   Ricky Charlet   : Redcreek Communications   : usa (510) 795-6903

-- 
  Ricky Charlet   : Redcreek Communications   : usa (510) 795-6903