[sqlalchemy] Re: Database locking

2010-04-26 Thread gazza
Thanks Michael. Not sure if this is the only thing I need to do. Why disable connection pooling? Thanks, Garyc On Apr 26, 10:32 am, Michael Bayer mike...@zzzcomputing.com wrote: gazza wrote: Hello, I am using multiple servers to access a sqlite db via sqlachemy. I am using the latest

Re: [sqlalchemy] Re: Database locking

2010-04-26 Thread Michael Bayer
gazza wrote: Thanks Michael. Not sure if this is the only thing I need to do. Why disable connection pooling? it means the app will release filehandles completely when a connection is released, and also that individual threads in your app will use distinct connections. The QueuePool

Re: [sqlalchemy] Re: Database locking

2010-04-26 Thread gary clark
Subject: Re: [sqlalchemy] Re: Database locking To: sqlalchemy@googlegroups.com Date: Monday, April 26, 2010, 4:39 PM gazza wrote: Thanks Michael. Not sure if this is the only thing I need to do. Why disable connection pooling? it means the app will release filehandles completely when