On Feb 13, 2007, at 9:39 PM, johnf wrote:
> psycopg is different from the other database adapter because it was
> designed
> for heavily multi-threaded applications that create and destroy
> lots of
> cursors and make a conspicuous number of concurrent INSERTs or
> UPDATEs. Every
> open Python connection keeps a pool of real (UNIX or TCP/IP)
> connections to
> the database. Every time a new cursor is created, a new connection
> does not
> need to be opened; instead one of the unused connections from the
> pool is
> used. That makes psycopg very fast in typical client-server
> applications that
> create a servicing thread every time a client request arrives.
>
> So as I read above two cursors two connections.
That would be a strange implementation of the dbapi, since a lot of
settings are made on the connection itself. I don't see how you could
issue a command like connection.rollback().
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
