Re: OpenLDAP performance vs. PostgreSQL

[Peter Mogensen <apm@mutex.dk>]

Buchan Milne wrote:

>>index  cn eq
> 
> 
> You index only the objectclass and cn attributes ...

Yes. But even the lookup on cn is slow.


>>    $mesg = $ldap->search(
>>                           base   => "dc=nodomain",
>>                           filter => "(pif=$i)"
> 
> 
> .. then you search with a filter that searches on the pif attribute, which you 
> haven't indexed.

I know... And it is very slow, and it would be better in a real
application to index "pif".
However... forget the last part of the test. Right now I'm only worrying
about why lookup on "cn" is 5 times slower than query on a primary key
in PostgreSQL.

Peter