[Zope] Zope + Postgresql = poor performance

[Hannu Krosing]

marc lindahl wrote:
> 
> I don't think single threaded necessarily means slower...
> Perhaps the performance problem lies elsewhere.

Unfortunately single-threaded in zope means "when postgres
> >> is executing one query all the rest are queued" as it 
allocates one connection per thread.

> >
> > Felipe Alvarez Harnecker wrote:
> >>
> >> Hi Zopistas,
> >>
> >> I'm having extremely poor performance with
> >>
> >> zope  2.1.6
> >> postgresql 7.0.2
> >> pygresqlda  0.3rjr2
> >>
> >> actualy zope create just one connection to postgres, so when postgres
> >> is executing one query all the rest are queued. Just image the mess
> >>
> >> So, can one tell me where to look at ?
> >
> > You are probably running zope single-threaded - this may happen if you
> > start zope up from pcgi ( or just say so in your zope start file)
> >
> >

------------
Hannu