[Grok-dev] Re: Apache support for Grok

[Christian Theune]

Am Donnerstag, den 11.01.2007, 23:13 +0100 schrieb Martijn Faassen:
> Philipp von Weitershausen wrote:
> > Martijn Faassen wrote:
> >> Any other ideas to make deploying in a shared hosting environment more 
> >> possible? It would be nice if there were some hack that would make 
> >> Zope 3 + ZODB work in a fairly standard shared hosting setup.
> > 
> > I agree. When using sqlite in trac, I think it opens a new connection to 
> > the database on every request. 
> 
> I also know that sqlalchemy does something to make sqlite deal with 
> multithreaded environments, but I don't think it can do multiprocess 
> environments.
> 
> > Perhaps we can start out by doing the 
> > same with the ZODB, and then later optimize by keeping a global 
> > connection pool around, or something. My lack of knowledge how exactly 
> > the ZODB works here (I know filestorage uses locks...) and how others 
> > (trac, svn, etc.) deal with these kinds of things from within Apache 
> > definitely shows ;).
> 
> I think this may be a question for Christian. Christian?

ZODB does that already. The usage of connections and the pooling within
one process exist.

One possibility would actually be to implement (or check whether it
exists already) a ZODB backend that uses SQL to store it's data in an
opaque form. Shane did this for PostgreSQL and ZC did it a while ago
with DCOracle2. I don't know whether this exists for MySQL too.

Christian

-- 
gocept gmbh & co. kg - forsterstraße 29 - 06112 halle/saale - germany
www.gocept.com - ct at gocept.com - phone +49 345 122 9889 7 -
fax +49 345 122 9889 1 - zope and plone consulting and development
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Dies ist ein digital signierter Nachrichtenteil
Url : http://mail.zope.org/pipermail/grok-dev/attachments/20070112/4e156612/attachment.bin