[pybsddb] Problem scanning large hashed database

[Jesus Cea]

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

andrew wrote:
>> If you want to query by range, like in your example, keep that index in
>> a btree. That btree can be in another database file, or in the same
>> file, with a separate logical database created as a btree.
> 
> Thanks for your advice, Jesus. I'll look into creating that separate
> index.

BTrees have range queries. Use them.

If your query is big enough, you can find again the "out of locks"
problem, though. Follow my previous advice about partitioning the query,
or using not isolated cursors.

Good luck with your project.

Time to go home. Bye!.

- --
Jesus Cea Avion                         _/_/      _/_/_/        _/_/_/
jcea at jcea.es - http://www.jcea.es/     _/_/    _/_/  _/_/    _/_/  _/_/
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

iQCVAwUBSTh4Gplgi5GaxT1NAQKpRwP5AQyThnPmCvbLfk3ozvswI5DST9G0rz9e
0JQJLfvr46NR9zeczmM9MUaUtlzjkPyMGZQT2MtGef+ZCt9JyvTd9mHDjCv7i2XW
zycHfoYwpDBPB3l3e+NNLCU0Hq+QkU2SG9sr8mEA5LfsCLMA0F89LZ8hy+sUceuN
nlJ4mZ5T2Dw=
=8/+H
-----END PGP SIGNATURE-----