From: Edmund L. <el...@in...> - 2003-03-12 15:46:11
|
On 03/12/2003 11:28:19 AM Marcos wrote: >OK, now everything goes back to the original server. We have reached an >acceptable performance using cx_Oracle instead of DCOracle2. It seems >that our DCOracle2 module was not behaving multithreaded (anybody >translate that into English). Only one query was active at a time. > >We are getting 8 pages/second/Webware process (Python only uses 1 cpu). Good info, thanks. I was going to suggest that the DB module might be the problem (really!). I find that it is useful to monitor the connections to see how many are active, whether they are hung (due to connection leaks), etc. I've not used the Oracle modules, and not on a different machine, but when I run Postgres on the same machine as Webware, I monitor the connections with the following shell script: while true; do ps ax|grep postgres; sleep 3; clear; done It must be possible to do the same kind of thing when Oracle on a different machine is involved... BTW, 8 pages/sec still seems low... if you're doing lots of queries per page, you might want to consider using either stored procedures, or bind variables if cx_Oracle supports them. ...Edmund. |