Hey, I was wondering if it would be possible to add some extra logging to the QueuePool for when its using overflow connections vs a connection out of the pool.
We currently are using a pool_size of 1 and a max overflow of 10. These were just random settings set in a library and no one really noticed at first, but now we are starting to increase our pool_size but want to get some insights on how its working and if it'll improve our application. For our app design we have paster running 10 worker threads and we are using the threadlocal strategy. Should we have a pool_size for the amount of worker threads we have so that they each get their own? My understanding of how the QueuePool is working is it'll pull a connection from the queue and it'll mark that connection with the thread that accessed it, so for our current setup of a pool_size of 1, we'll have a single worker who gets the pooled connection and everyone else is going to get overflow connections, right? So, in our specific case where we don't use transactions at all, it probably makes most sense to remove threadlocal strategy and to increase our pool_size to the amount of workers we have? Thanks, John -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.
