[pybsddb] Closing a large read only btree takes a long time - possible to use DB_NOSYNC?

[Chris Mulligan]

I'm working on a test case now, I'll send you the code in a couple hours
when I've confirmed it "works".

-----Original Message-----
From: pybsddb-bounces at argo.es [mailto:pybsddb-bounces at argo.es] On Behalf
Of Jesus Cea
Sent: Wednesday, March 26, 2008 5:18 PM
To: Python bindings for Oracle Berkeley DB
Subject: Re: [pybsddb] Closing a large read only btree takes a long time
- possible to use DB_NOSYNC?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Chris Mulligan wrote:
| Closing a file with ~1 million keys, and ~350MB on disk takes about 5
| minutes.

Please, prepare a testcase and I will look at it. That is, two scripts:
one generating the database and other reproducing the long delay.

| After spending a long time reading various scripts and files about
bsddb
| and Berkeley DB in general I'm beginning to wonder whether calling
| DB->close with the DB_NOSYNC option would help. It appears to be
| unsupported in python, but I admit that the bsddb code has confused me
| slightly.

Since the database is read-only, DB_NOSYNC would be no useful. The right
thing to do is to diagnose the problem. I need a small testcase able to
reproduce the issue.

- --
Jesus Cea Avion                         _/_/      _/_/_/        _/_/_/
jcea at argo.es http://www.argo.es/~jcea/ _/_/    _/_/  _/_/    _/_/  _/_/
jabber / xmpp:jcea at jabber.org         _/_/    _/_/          _/_/_/_/_/
~                               _/_/  _/_/    _/_/          _/_/  _/_/
"Things are not so easy"      _/_/  _/_/    _/_/  _/_/    _/_/  _/_/
"My name is Dump, Core Dump"   _/_/_/        _/_/_/      _/_/  _/_/
"El amor es poner tu felicidad en la felicidad de otro" - Leibniz
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iQCVAwUBR+q9aZlgi5GaxT1NAQJARwQAnzNhS+2ltn0jAxdhJG0q0csGVW+S2IOs
K7ZHb18YfJZOvqlVWsraWTBQSiqzO6BoQFtyXY6/+AdsIHi7mlKfBSoPCquBfrVE
wGwfdPGY0FUhxGbFxaaCrKQRBXFgZ2EGKXCNS9hQWV9V7PHs85DGXdocfAf85JwE
U3rwpYDw86M=
=aUGs
-----END PGP SIGNATURE-----
_______________________________________________
pybsddb mailing list
pybsddb at argo.es
http://mailman.argo.es/listinfo/pybsddb
http://www.argo.es/~jcea/programacion/pybsddb.htm