[DB-SIG] Webware and Oracle/high load

Marcos msanchez@grupoburke.com
12 Mar 2003 15:06:58 +0100


The right figure is 8/s (thank the proofreader).

I think webware is doing alright for this overloaded machine (SunOS,
4cpu, 3GB RAM, not dedicated), but I don't have any experience in
benchmarking; I am usually happy when things finally just _work_.

El mi=E9, 12-03-2003 a las 13:50, M.-A. Lemburg escribi=F3:
> Marcos wrote:
> > We are testing cx_Oracle ant it seems to behave much better with this
> > number of threads. It is finally working (I hate changing) on the same
> > machine the Oracle+Pound+Apache is. Now we are getting 8
> > pages/minute/Webware instance (each Webware uses up one CPU). We are no=
w
>=20
>          ^^^^^^ not per second ? Is WebWare really *that* slow ?
>=20
> > micro-optimizing.
> >=20
> > cx_Oracle has dumped core a couple of times. It is a relative problem,
> > since Webware restarts in less than 4 seconds, but it always troubles
> > me...
> >=20
> > With both modules, Webware seems to stop responding to ^C whenever an
> > error happens in the oracle level; we have to -KILL it. :-\ I'll review
> > whether I am closing cursors in case of an error.
> > -----
> > ref Webware: An application server in pure Python http://webware.sf.net=
/
> > ----
> > El lun, 10-03-2003 a las 21:25, Marcos S=E1nchez Provencio escribi=F3:
> >=20
> >>I am setting up a high load web app with webware using DCOracle2, but
> >>seem to get strange dead times. Would cxOracle or SQLRelay behave bette=
r
> >>for many (100-200 threads)? Any caveats about using DCOracle2 with this
> >>number of threads? The docs say I can share a connection among threads,
> >>but do I get separate trans per cursor?
> >>
> >>Thank you
> >>--=20
> >>Marcos S=E1nchez Provencio <msanchez@grupoburke.com>
> >>www.burke.es
> >>
> >>
> >>_______________________________________________
> >>DB-SIG maillist  -  DB-SIG@python.org
> >>http://mail.python.org/mailman/listinfo/db-sig
> >=20
> >=20
> >=20
> >=20
> > _______________________________________________
> > DB-SIG maillist  -  DB-SIG@python.org
> > http://mail.python.org/mailman/listinfo/db-sig
>=20
> --=20
> Marc-Andre Lemburg
> eGenix.com
>=20
> Professional Python Software directly from the Source  (#1, Mar 12 2003)
>  >>> Python/Zope Products & Consulting ...         http://www.egenix.com/
>  >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
> ________________________________________________________________________
> Python UK 2003, Oxford:                                     20 days left
> EuroPython 2003, Charleroi, Belgium:                       104 days left
>=20
>=20
> _______________________________________________
> DB-SIG maillist  -  DB-SIG@python.org
> http://mail.python.org/mailman/listinfo/db-sig