Re: [sqlalchemy] Slow response in concurrent threads

2015-11-21 Thread Mike Bayer
if the issue is only with threads and not concurrent processes then the DBAPI in use would be suspect. I don't see which driver you are using but perhaps it is not releasing the GIL while it waits for a server response. I'd identify which driver this is, produce a test case that isolates it

[sqlalchemy] Slow response in concurrent threads

2015-11-21 Thread Mohsen Lotfizad
Hi, I have a project using pyramid + ZopeTransactionExtension + SQLAlchemy + MSSql. The problem is that when I call *foo_avarage_one_month* once (using curl) it took about 5 second to response, but when I call it with 2 session concurrently, it took about 9 second to response! I run my project