Database connection caching

[Swaroop C H]

On 18 Mar 2005 04:52:03 -0800, lbolognini at gmail.com
<lbolognini at gmail.com> wrote:
> Hi all,
> 
> is there an alternative way of:
> 
> - create a connection object
> - open the connection
> - close the connection
> 
> every time one has to run a query.

Why not use cursor objects with a single connection object?

You can have any number of cursor objects and can run with a single
connection object

A good introduction is at http://www.amk.ca/python/writing/DB-API.html

Regards,
-- 
Swaroop C H
Blog: http://www.swaroopch.info
Book: http://www.byteofpython.info