On 2009-12-7 17:34, Jim Fulton wrote: > On Mon, Dec 7, 2009 at 11:00 AM, Alan Runyan<runy...@gmail.com> wrote: > ... >> A design pattern for RDBMS is to have 2 pools. READ pool and WRITE pool. >> Often the READ pool comes from some replica and WRITE is to the master. >> I'm unsure this pattern would work for ZODB. I know Malthe was thinking >> about this but unsure if he had anything concrete. > > Would both pools be used by a single process?
From what I gather on high-load sites it is common to use one pool for queries, and a second pool for updates. Both are used in the same process(es)/threads. Wichert. -- Wichert Akkerman <wich...@wiggy.net> It is simple to make things. http://www.wiggy.net/ It is hard to make things simple. _______________________________________________ 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