--On 27. Mai 2007 23:27:30 -0700 Alchemist <[EMAIL PROTECTED]> wrote:
I developed my web application in TurboGears 1.0.1 (Python 2.4, CherryPy 2.2.1 and SQLAlchemy 0.3.6) and used Postgresql 8.2 as my backend. Also, I am using psycopg2. I am running stress tests (using tools such as WAPT and Web Application Stress Tool) to test the load supported by the web application. When executing the stress tests I am setting 2 simultaneous threads forcing a few GET requests on the machine (server) hosting my web app. The results I obtained seem very bad: 1. the server seems to crash easily when more than 1 thread throws GET requests 2. SQLAlchemy is missing some sequence (unique) ids and so some database INSERTS are failing
I've done a lot of stress-testing with SA under Zope (also a threaded environment) and I have not seen an issue. My configuration: Zope 2.8-2.10, Python 2.4.4, latest SA, latest psycopg2, z3c.sqlalchemy, Postgres 7.4.6 -aj
pgprYhvQLBjEq.pgp
Description: PGP signature
