Re: [sqlalchemy] SQL connections rising into the hundreds / thousands

2016-02-04 Thread Daniel Cochran
Hi Michael -- thank you for the reply. everything looks fine, except what does get_sqlAlchemy() do? If that > creates a new SqlAlchemy instance each time, then you're making new > connection pools on every request. even then, when these are garbage > collected the underlying database

[sqlalchemy] SQL connections rising into the hundreds / thousands

2016-02-03 Thread Daniel Cochran
I recently switched to SQL Alchemy to take advantage of connection pooling, but I notice that my SQL server will have anywhere from 30-60 open connections throughout the day, ("threads_connected"), and sometimes it randomly climbs up to the max of 2000 and just completely falls over. This