Hi, I have a question about the alias dereferencing and mdb performance. I installed from source ldap 2.4.42 with mdb support. In our current directory we have 367 007 objects and 42262 aliases. During the test I observed that the MDB is slower than the HDB during search with aliases dereferencing. I performed test search in small scope (11115 objects where 6991 is aliases to other part of structure) with filter objectClass=User and dereferencing aliases set to always. I see that query to HDB take about 20s and query to MDB about 29s. On both server the load are low. Are in ldap configuration any option than can tune the alias dereferencing or we should redesign the structure to reduce number of aliases?
*Karol*
Hi Karol,
Same problem here. Quanah suggested that we have to use dereferncing set to when finding but with that option we have problem that some data is missing from answer although speed is as with HDB.
My database is in range from 1 Milion to 50 Milion objects.
Br
Sasa
On 2 September 2015 at 07:42, Karol Chrapek kchrapek@fgtsa.com wrote:
Hi, I have a question about the alias dereferencing and mdb performance. I installed from source ldap 2.4.42 with mdb support. In our current directory we have 367 007 objects and 42262 aliases. During the test I observed that the MDB is slower than the HDB during search with aliases dereferencing. I performed test search in small scope (11115 objects where 6991 is aliases to other part of structure) with filter objectClass=User and dereferencing aliases set to always. I see that query to HDB take about 20s and query to MDB about 29s. On both server the load are low. Are in ldap configuration any option than can tune the alias dereferencing or we should redesign the structure to reduce number of aliases?
*Karol*
Could you get me a little more info about dereferencing set?
*Karol Chrapek* | Infrastructure Architect
Infrastructure Division
mobile: +48 660 623 422
2015-09-03 9:04 GMT+02:00 Saša-Stjepan Bakša ssbaksa@gmail.com:
Hi Karol,
Same problem here. Quanah suggested that we have to use dereferncing set to when finding but with that option we have problem that some data is missing from answer although speed is as with HDB.
My database is in range from 1 Milion to 50 Milion objects.
Br
Sasa
On 2 September 2015 at 07:42, Karol Chrapek kchrapek@fgtsa.com wrote:
Hi, I have a question about the alias dereferencing and mdb performance. I installed from source ldap 2.4.42 with mdb support. In our current directory we have 367 007 objects and 42262 aliases. During the test I observed that the MDB is slower than the HDB during search with aliases dereferencing. I performed test search in small scope (11115 objects where 6991 is aliases to other part of structure) with filter objectClass=User and dereferencing aliases set to always. I see that query to HDB take about 20s and query to MDB about 29s. On both server the load are low. Are in ldap configuration any option than can tune the alias dereferencing or we should redesign the structure to reduce number of aliases?
*Karol*
openldap-technical@openldap.org
-
Karol Chrapek -
Saša-Stjepan Bakša