--On 27. Mai 2007 23:27:30 -0700 Alchemist <alex...@gmail.com> 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
6 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: stress tests / multi...