Erik Dahl wrote:
> I haven't dove into the relstorage yet but have heard it will perform
> better. Not sure I understand why though. Isn't it just putting
> pickles into a single table with an index on the oid? (or oid / serial).
Yes. In theory, ZEO should be about the same speed, but all the
measurements I've done suggest ZEO has excessively high internal
latency. I suspect ZEO uses Python sockets inefficiently, or that the
GIL may be getting in the way. I know FileStorage isn't the problem,
since bare FileStorage can read or write about 20,000 objects per second
on my laptop.
Jim is working on a newer version of ZEO, so maybe that will close the
performance gap. For now, all the people who have told me they are
using RelStorage seem to be happy with the improved speed.
For more information about ZODB, see the ZODB Wiki:
ZODB-Dev mailing list - ZODB-Dev@zope.org