oracle backend doesn't cache connections

[Stefan Bethge]

Hello,

i've recently found out that django does not cache connections to the
database but connects for every request and disconnects afterwards. I
don't know if this is fine for postgresql/database servers on the same
machine. Maybe using pg_pool helps a lot for postgres. However, in our
setup, we have an oracle server on another machine in the network.
Connecting to oracle takes a while, sometimes up to some seconds,
which is completely unusable for a live website. Until now, I've not
heard of a similar solution like pg_pool for oracle (and sqlrelay is
not supported for now in django, http://code.djangoproject.com/ticket/409).
Are there plans to implement some kind of connection caching or may I
have not seen a connection pool daemon for oracle?
Or is it in some way possible to manage the connections in the django
application itself?

Thanks for any suggestion,
Stefan Bethge

[Stefan Bethge]

Hi again,

I've found out recently that there is Oracle Connection Manager which
might just be what I need.
I still need to test it though.

Later,
Stefan

On Sep 19, 2:26 pm, Stefan Bethge <kaschin...@googlemail.com> wrote:
> Hello,
>
> i've recently found out that django does not cache connections to the
> database but connects for every request and disconnects afterwards. I
> don't know if this is fine for postgresql/database servers on the same
> machine. Maybe using pg_pool helps a lot for postgres. However, in our

> setup, we have anoracleserver on another machine in the network.
> Connecting tooracletakes a while, sometimes up to some seconds,

> which is completely unusable for a live website. Until now, I've not

> heard of a similar solution like pg_pool fororacle(and sqlrelay is
> not supported for now in django,http://code.djangoproject.com/ticket/409).