[Grok-dev] Re: Apache support for Grok

[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?

Regards,

Martijn