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

Re: LMDB file size, again

Christian Sell wrote:
You're being stupid.

let's say I am stubborn. As I mentioned, I have the requirement that the user be
able to copy the database file away on their USB stick (or send it via email,
for that matter). With SQLite, that is no problem. But with LMDB under Windows
the user is looking at a huge file, which will be unacceptable in all
likelihood. I also must allow the user to copy using file system tools, and not
some custom utility.

So I take it that LMDB is simply not designed or suitable for such a scenario.

Windows and its lack of reasonable sparse file support makes it not a suitable OS. (Windows supports sparse files, but not by default, and there is a 30% performance degradation when using that support in LMDB.)

If you're stuck with Windows and these other requirements then I recommend you use something other than LMDB, it is not appropriate for your use case.

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