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. Shane _______________________________________________ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev