[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: (ITS#3851) Berkeley DB Scalability Patch

>I think you are not doing a broad enough test to really understand the 
>validity of your patch, and I suggest testing with more than 13 indices, 
>and letting it run to completion.

I tested further by adding six more equality indices to the 13 index 
case. The result reiterates my previous result. As I told you before, 
the effects of adding equality indices are minor. It took 415 minutes 
for slapadd with six more equality indices to complete. That is only 50 
minutes more than 365 minutes taken with 13 indices. Here is a brief 
comparison of the index settings :

Quanah's                  Jong-Hyuk's
equality only                              
14                               12
eq, substring                               
4                                 2
eq, substring, approx                  3                                 5
21                               19

I would say that the degree of indexing in the two setups are 
comparable. (Your setting has two more indices but that can be 
compensated by two additional approximate indices in my setting.)

>My indices are:
># Indices to maintain
>index   default eq
>index   objectClass
>index   uid
>index   departmentNumber
>index   cn              eq,sub,approx
>index   sn              eq,sub,approx
>index   l
>index   ou
>index   telephonenumber eq,sub
>index   userpassword
>index   givenName       eq,sub,approx
>index   mail
>index   carLicense
>index   employeeType
>index   homephone       eq,sub
>index   mobile  eq,sub
>index   pager   eq,sub
>index   o
>index   roomNumber
>index   preferredLanguage
>index   postalCode
>index   st
>and DB_CONFIG is:
># $Id: DB_CONFIG,v 1.1 2004/04/02 19:27:11 quanah Exp $
>set_cachesize 1 713031680 0
>set_lg_regionmax 262144
>set_lg_bsize 2097152
>set_lg_dir /var/log/bdb
>Quanah Gibson-Mount
>Product Engineer
>Symas Corporation
>Packaged, certified, and supported LDAP solutions powered by OpenLDAP: