Re: [SQLObject] Connection instance ignored ?

2009-02-09 Thread Oleg Broytmann
On Sun, Feb 08, 2009 at 06:16:01PM -0500, Stef Telford wrote: > seeing about 190 connects/disconnects on the postgreSQL side. Now, > since a connection is costly (believe me, it is ;), how can I get > these down to (in theory) 1. I know that may seem unrealistic, but > still, there shouldn't be 190

Re: [SQLObject] Connection instance ignored ?

2009-02-09 Thread Stef Telford
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Oleg Broytmann wrote: > On Sun, Feb 08, 2009 at 06:16:01PM -0500, Stef Telford wrote: >> seeing about 190 connects/disconnects on the postgreSQL side. >> Now, since a connection is costly (believe me, it is ;), how can >> I get these down to (in theory

Re: [SQLObject] Connection instance ignored ?

2009-02-09 Thread Oleg Broytmann
On Mon, Feb 09, 2009 at 12:35:47PM -0500, Stef Telford wrote: > slaveConnection._pool = None It must be exactly opposite: slaveConnection._pool = [] Well, an empty list is the default value, so by default SQLObject should not disconnect but use a low-level connection from the pool. Oleg.

Re: [SQLObject] Connection instance ignored ?

2009-02-09 Thread Oleg Broytmann
Oh, BTW, do you use transactions? And call transaction.commit()? Oleg. -- Oleg Broytmannhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Cr

Re: [SQLObject] Connection instance ignored ?

2009-02-09 Thread Stef Telford
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Oleg Broytmann wrote: > Oh, BTW, do you use transactions? And call transaction.commit()? > > Oleg. Hello again Oleg, Nope, well, I mean I -plan- to, but currently, the connection is being made at the start of the page and then I go through get'ting

Re: [SQLObject] Connection instance ignored ?

2009-02-09 Thread Oleg Broytmann
On Mon, Feb 09, 2009 at 01:03:53PM -0500, Stef Telford wrote: > Oleg Broytmann wrote: > > Oh, BTW, do you use transactions? And call transaction.commit()? > > > I don't see why/how wrapping everything in a transaction would > change things.. but then.. that's jst me :) Transaction object in