Lorenzo> is there an alternative way of: Lorenzo> - create a connection object Lorenzo> - open the connection Lorenzo> - close the connection
Lorenzo> every time one has to run a query. Sure, create a Queue.Queue object and stuff a number of connections into it. When you want a connection call the queue's .get() method. When you're done with it .put() it back. This has the other nice feature that a program with a large number of threads can't overwhelm your database. Skip -- http://mail.python.org/mailman/listinfo/python-list