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

To: Quanah Gibson-Mount <quanah@symas.com>
Subject: Re: Efficient way to count number of entries in a database?
From: Karsten Heymann <karsten.heymann@gmail.com>
Date: Wed, 15 Nov 2017 08:41:37 +0100
Cc: Michael Ströder <michael@stroeder.com>, openldap-technical@openldap.org
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=FfwvzkFt2OE9g14M/iCuYA1Gyjy+lJWIfCVWDaCMEts=; b=NeYll5ziBNn/WAklUli6M0QYgo/+O1JIOWSiafXdeLl8FpFoEqCfY5L9ahUFjD2CSq Tutv2q3vhid76LdQdyaqt16zzgKAlPkW8lrzWDnNX41/cX82A23loCSldHk6L+R1NTRj Humb7aoaRhv6ZPwJNhT3K1fDnctCM2xJ6cKMvANTszGjjV2P6Bi+N/TmwV/YPclb6jIj ce5bT8mjeujYRWLihgMGgYSlE4YNeqfgLZhbZpNPeQhYAjaPoRYE0vFUGxwrk7ve1tYi Bev8In8Jgit7qUup9U2ezmbgcXpHayx6bPVkwIys8pAepTEW1+mL5Td6iiJofimZU0b/ aW3w==
In-reply-to: <97B0E473A0CC3B948300A9F4@192.168.1.30>
References: <CAL017hDRC7jxs2-xYk2g8qLguJw+gjTdUXvwk-UkyPXAKvgcAg@mail.gmail.com> <0e7584ba-c0e3-ed17-4f03-2f5e18fe55bb@stroeder.com> <CAL017hBFFJFpnG81yU6XrDugjAOs+DMnFaLbfsuwKPmQT354iA@mail.gmail.com> <WM!45daa2f2057c69e622e844e7956fb5025b112e841835f8c98b4c03b3c767b7ebc7f9a0a85e564b4799a38b0c80613065!@mailstronghold-3.zmailcloud.com> <97B0E473A0CC3B948300A9F4@192.168.1.30>

Hi Quanah,

2017-11-14 16:46 GMT+01:00 Quanah Gibson-Mount <quanah@symas.com>:

mdb_stat -s id2e /path/to/mdb/db | grep Entries
Entries: 3993833

That's exactly what I needed. Thanks a lot!

btw for those using debian as well, mdb_stat is in the lmdb-utils package

Karsten

References:
- Efficient way to count number of entries in a database?
  - From: Karsten Heymann <karsten.heymann@gmail.com>
- Re: Efficient way to count number of entries in a database?
  - From: Michael Ströder <michael@stroeder.com>
- Re: Efficient way to count number of entries in a database?
  - From: Karsten Heymann <karsten.heymann@gmail.com>