[Grok-dev] Re: Off topic: Performance of Sqlite3 vs. Zodb

Martijn Faassen 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 mailing list