On Tue, Aug 28, 2012 at 06:31:05PM +0200, Vincent Pelletier wrote: > On Tue, 28 Aug 2012 16:31:20 +0200, > Martijn Pieters <m...@zopatista.com> wrote : > > Anything else different? Did you make any performance comparisons > > between RelStorage and NEO? > > I believe the main difference compared to all other ZODB Storage > implementation is the finer-grained locking scheme: in all storage > implementations I know, there is a database-level lock during the > entire second phase of 2PC, whereas in NEO transactions are serialised > only when they alter a common set of objects.
This could be a compelling point. I've seen deadlocks in an app that tried to use both ZEO and PostgreSQL via the Storm ORM. (The thread holding the ZEO commit lock was blocked waiting for the PostgreSQL commit to finish, while the PostgreSQL server was waiting for some other transaction to either commit or abort -- and that other transaction couldn't proceed because it was waiting for the ZEO lock.) Marius Gedminas -- People who think, "Oh this is a one-off," need to be offed, or perhaps politely removed from the project. -- George Neville-Neil
Description: Digital signature
_______________________________________________ For more information about ZODB, see http://zodb.org/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev