python缓存结果集式的cursor可以用来提高性能。

例子：

#!conding:utf-8from mysql.connector import errorcodeimport mysql.connectorcnx=Nonecursor=Nonetry:    cnx = mysql.connector.connect(host='192.168.1.201',port=3306,user='admin',password='131417')    cursor=cnx.cursor(buffered=True)#buffered=True会把结果集保存到本地，这样可以提高性能    cursor.execute('select * from studio.t where id=7')    for x in cursor:        print xexcept mysql.connector.Error,err:    print errfinally:    if cursor is not None:        cursor.close()        cnx.close()