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