[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
--------------------------------------------------------------------
Total
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
>
>Regards,
>Quanah
>
>--
>Quanah Gibson-Mount
>Product Engineer
>Symas Corporation
>Packaged, certified, and supported LDAP solutions powered by OpenLDAP:
><http://www.symas.com>
>
>
>
>
>
>
>