[Zope-DB] Re: Reviving an old thread :: DCO2 and memleaks...

Dario Lopez-Kästen dario@ita.chalmers.se
Thu, 9 Jan 2003 16:06:32 +0100


----- Original Message -----
From: "Geir Bækholt" <geirh@funcom.com>
>
> I am running mostly very mundane queries , not returning many rows,
> even, but we do have a fair amount of traffic... (well.. squid eats mos=
t
> of it)
>
> Did anyone ever find a workaround or fix for this ?

Nope, not yet.

We have no real clue of what the problems might be on the zope part of the
system. We do have a lot of oracle connection objects and we are trying to
cut down on them down to one per oracle schema (don't ask why we had more
than one per schema previously).

We have decided to fix our SQL in the first place and we are then going to
try to limit the amount of CPU-time that oracle will give to each query, and
if it is exceeded we abort the query. This is to avoid hangups on the db
server. Hopefully this will also give us info on what queries are the ones
affected.

I will report back on whether this is sucessfull or not.

/dario