From: Ben <be...@me...> - 2004-03-13 07:27:33
|
RE: my connection pool increasing (SQLObject 0.5.2, FreeBSD, psychopg / Postgres): i've isolated where the connection numbers are increasing: self.itemcls.select(orderBy=self.orderBySQL)[start:start+self.pa\ geLen] i found this in the release notes: Using .select() would hold on to a connection, and also release it back to the connection pool. Very un-threadsafe and all-around bad. is this bug still in existence? how do i select limit / offset without keeping allocating a connection? thanks, Ben Lee |