Re: (ITS#7657) Alias dereferencing with MDB slow compared with BDB

[hyc@symas.com]

Mark.Cairney@ed.ac.uk wrote:
> Hi Howard,

Hi Mark,
   thanks for the feedback.

For completeness' sake, the tool I used to generate our test dataset is in
 http://www.openldap.org/its/index.cgi?findid=8875#followup14
> 
> Just to confirm that I'm seeing significantly better results with the
> 2.4.48 RC release for querying OUs full of aliases and de-referencing them:
> 
> Comparing 2 servers with the same data on them (one 2.4.47, the other
> 2.4.48 with the new patch) and just after restarting slapd yield the
> following:
> 
> 2.4.48: 0.52s user 0.09s system 46% cpu 1.315 total (with a small spike
> in CPU)
> 
> 2.4.47: 0.46s user 0.94s system 0% cpu 3:39.89 total (with the CPU
> spiking to 100% on the server for the duration of the query)
> 
> 
> This is for an OU with 11932 entries in it (all aliasedObjects)
> 
> On 15/07/2019 17:07, Howard Chu wrote:
>> Fyi, we recently revisited this issue and are seeing improved results with
>> commit e90e8c7d3c12d897bb0584ba04dc519d4f23acf9 in master.
>>
> 


-- 
  -- Howard Chu
  CTO, Symas Corp.           http://www.symas.com
  Director, Highland Sun     http://highlandsun.com/hyc/
  Chief Architect, OpenLDAP  http://www.openldap.org/project/