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

Antw: Re: Efficient way to count number of entries in a database?



>>> Karsten Heymann <karsten.heymann@gmail.com> schrieb am 14.11.2017 um 15:26 in
Nachricht
<CAL017hBrprNwGEQq88Zty7EF9O3uD8u43UMkTZOn-LgFTzvFQw@mail.gmail.com>:
> Hi Ulrich,
> 
> 2017-11-14 12:40 GMT+01:00 Ulrich Windl <Ulrich.Windl@rz.uni-regensburg.de>:
> 
>> >>> Karsten Heymann <karsten.heymann@gmail.com> schrieb:
>> > is there a more efficient way to count how many entries a ldap database
>> has
>> > than
>> >
>> > slapcat -b <suffix> | grep ^dn: | wc -l
>>
>> Here olmBDBDNCache from  cn=Database 1,cn=Databases,cn=Monitor seems to be
>> close to the number (10762 vs. 10770).
> 
> 
> I guess you are using the bdb/hdb engine? I'm using mdb and I don't have
> that attribute.
> 
> +Karsten

Hi Karsten

I avoided mdb so far, but maybe there's an equivalent of SQL's "select count(...) ..." for MDB that can be added to the monitor more or less easily ;-)

Regards,
Ulrich