Re: [sqlalchemy] How to Dispose of all Connections in a Pool in a Web Environment?

2022-11-11 Thread Mike Bayer
engine disposal is discussed in-depth at https://docs.sqlalchemy.org/en/14/core/connections.html#engine-disposal , so if that section is not clarifying then I'd want to know how it can be improved. your assertion would appear to be correct. On Fri, Nov 11, 2022, at 12:53 PM, mkmo...@gmail.com

[sqlalchemy] How to Dispose of all Connections in a Pool in a Web Environment?

2022-11-11 Thread mkmo...@gmail.com
I'm using the standard connection pool via engine: engine = sqlalchemy.create_engine('oracle://scott:tiger@foo', ...) conn1 = engine.connect() conn2 = engine.connect() I want to dispose and recreate the pool in a web environment. All new threads that connect should get a new

Re: [sqlalchemy] Large increase in memory use when upgrading from 1.3 to 1.4

2022-11-11 Thread Mike Bayer
We've identified a significant source of memory over-use in the 1.4 caching system, on the particular environment where it was discovered, an extremely long and complex query nonetheless created a cache key that used orders of magnitude more memory than the statement itself. A fix for this