[Grok-dev] Re: Off topic: Performance of Sqlite3 vs. Zodb
faassen at startifact.com
Thu Mar 13 17:47:19 EDT 2008
Alexander Limi wrote:
> On Thu, 13 Mar 2008 11:38:13 -0700, Sebastian Ware
> <sebastian at urbantalk.se> wrote:
>> I was surprised to find that Zodb was 20 times faster (but obviously
>> growing quite rapidly in size during the process) than Sqlite3. This
>> was a sursprise to me, but I wonder if this is what one would expect?
> It's certainly what I would expect, since the ZODB doesn't have to do
> any serialization, it just stores a Python pickle.
I'm not sure I understand that point: a Python pickle needs to be
produced, and Python's pickling process is a form of serialization.
I think it's important not to have too many expectations here - one can
tweak benchmarks left and right and get different results. Witness Roché
Compaan's ZODB versus RDB benchmarking on zodb-dev (where in the n-th
correction to the benchmark ZODB is scoring quite well too).
Performance depends a lot on what one is doing with the database, and
how one is doing it...
More information about the Grok-dev