3 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: Load capabilities wi...
FromSent OnAttachments
Fotinakis15 Jul 2008 22:32 
Andreas Jung15 Jul 2008 22:48 
Michael Bayer16 Jul 2008 07:54 
Subject:[sqlalchemy] Re: Load capabilities with default pool_size and max_overflow
From:Andreas Jung (lis@zopyx.com)
Date:07/15/2008 10:48:17 PM
List:com.googlegroups.sqlalchemy

--On 15. Juli 2008 22:32:35 -0700 Fotinakis <foti@gmail.com> wrote:

Hello SQLAlchemists,

What is (or what do you think is) the load that SQLAlchemy can handle with the default engine options of pool_size=5 and max_overflow=10? The application I'm working on has the potential for bursts of thousands of requests in a few seconds, so I am concerned about load.

Default settings are called that way because they make sense to possibly 80% of all use-cases. Don't expect that a high-traffic environment works without tuning. So the answer is basically: unlikely.

Is it appropriate to increase these values to some arbitrary number?

Those parameters are exposed as part of the API for performing such a tuning?!

-aj