hey there, i have a huge app that connects to MySQL. There are three threads that are continually connecting and disconnecting to the db. The problem is, if there is an error, it faults out sometimes without closing the connection. i connect like this. db = MySQLdb.connect(host="localhost", user="MyUser", passwd="MyPassword", db="Stuff") cursor=db.cursor()
then i use the cursor.execute("SELECT yadda yadda my question is, is there a way i can set up a global connection so that when the program loads, it connects once, then stays connected ? maybe i could assign instances of the cursor ? please someone let me know if you have any good ideas sk -- http://mail.python.org/mailman/listinfo/python-list