DB Pool
bcurtu
bcurtu at gmail.com
Tue Jul 22 06:19:00 EDT 2008
Hi,
I use MySQLdb lib to access my DB, because I want to opttimize my sql
queries. The application I'm working on has quite a few traffic load,
so I want to minimize the time of creating/destroying cursors:
My typical code is sth like:
cursor=con.cursor()
cursor.execute(sql)
all= cursor.fetchall()
cursor.close()
So, the question is... how can I minimize this cost? I was thinking on
Connection Pools, but I didn't find any good documentation or sample.
Any idea?
More information about the Python-list
mailing list