On 5 Jul 2006, at 19:43, Tom Jackson wrote:
performance from an SQL database. However, if you use the BDB
database, you
will still have to go through some sort of database API, either the
one which
exists, or a custom designed API. The purpose of the built in API
is to share
connections across threads and even virtual servers, but it isn't
really
suited for simple key/value lookup.
That's what I noticed when looking at Vlad's nsberkeleydb module. I
was expecting something more like the existing Tcl module for BDB
provided by Sleepycat themselves, except extended to always operate
in an enviroment and maintain its own pool.
I guess the nsdb driver is easier to implement, but it doesn't seem
ideal.
Overall, it seems like BDB or cdb would have the same memory
requirements of
an nsv array, but they require some kind of API to get to this
memory. Since
BDB has other advantages too, like the "secondary" databases with
other indexes to your data than just the primary key. This would be
very useful for finding only, say, blog entries belonging to one blog.
Plus they scale to many gigabytes on disk, something nsv doesn't.
On a side note: does anyone know if there are actual maintained,
production quality, BSD licensed versions of "Berkeley DB" out there?
Cheers,
Bas.
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.
