3 ms·
I suspect there are a few issues at play. First, with BDB I have to deserialize the entire object to get the UID - while I tell MySQL I'm only interested in 1 c
by smanek 17y ago
I suspect there are a few issues at play. First, with BDB I have to deserialize the entire object to get the UID - while I tell MySQL I'm only interested in 1 column. Second, with the simple query I'm literaly just traversing a b-tree - which is the exact same thing that mysql does since I told it to build an index on the relevant column (except with BDB I do so in Lisp instead of raw C).
- gaius 17y agoI think a more representative test would be BDB vs SQLite, since they are architecturally more similar (e.g. there's no SQLite "daemon", it's a C library).