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

[Martijn Faassen]

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).

http://www.upfrontsystems.co.za/Members/roche/where-im-calling-from/zodb-benchmarks

http://www.upfrontsystems.co.za/Members/roche/where-im-calling-from/zodb-benchmarks-revisited

Performance depends a lot on what one is doing with the database, and 
how one is doing it...

Regards,

Martijn