Hi Michael, Thanks for your response on this. > the engine is using a connection pool which by default will keep five > connections opened persistently. It also has an "overflow" of 10 > additional connections which are opened on an as-needed basis and > closed after usage. At the point of 15 connections in use, the pool > throttles additional requests until a connection is available. This > is of course all entirely configurable and the docs explain how to do > this in detail. > > Each of your Session instances will procure a connection from the pool > when they are first used (such as, issuing a query). They then hold > on to that connection persistently, which is considered to be the > active transaction, until you rollback(), commit(), or close() the > session, or the session is garbage collected. The "persistent > transaction" behavior of session is known in the 0.4 series as > "transactional" and in the 0.5 series as "autocommit=False". If you > flip this flag, then the Session only pulls connections from the pool > for each individual statement execution and/or flush(), and returns it > immediately afterwards.
This makes perfect sense to me, I've been looking at my application log data this morning and can see the connections being created, pooled and checked out exactly as I would expect which is a very good sign. I can however see that my application can potentialy see a large number of connections in use though, perhaps a maximum of around 30 at any one time due to concurrent 'threads' in the FSM, I'll look into changing the configuration options and creating a bigger pool, this will no doubt help the situation. Cheers for your advice, Heston --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---