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 What configuration options for SQLAlchemy / CherryPy / Psycopg / Postgresql should I look into to solve these issues? Thank you. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---