[DB-SIG] Webware and Oracle/high load

[M.-A. Lemburg]

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

         ^^^^^^ not per second ? Is WebWare really *that* slow ?

> 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
Marc-Andre Lemburg
eGenix.com

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