python - django 中使用原生mysql进行查询 如何减少连接次数
量化分析 2018-08-12 08:36:44 代码如下:
from DBUtils.PooledDB import PooledDB
MYSQL_HOST = settings.MYSQL_HOST
USER = settings.MYSQL_USER
PASSWORD = settings.MYSQL_PASSWD
DB =settings.MYSQL_DBNAME
PORT = settings.MYSQL_PORT
pool = PooledDB(pymysql, mincached =50,maxcached=100, maxconnections=100,host=MYSQL_HOST, user=USER, passwd=PASSWORD, db=DB, port=PORT,charset='utf8') # 5为连接池里的最少连接数
def myview(request):
# 在myview函数中执行查询,每次用户请求一次就进行查询一次
cmd = "SELECT DISTINCT t.cidno,t.fname, t.region, t.case_time, t.case_no, t.court, t.basis_no, t.detail, t.fullfil, t.publish_time FROM dw_person_dishonest t where t.fname='{0}' and CONCAT(LEFT(t.cidno, 4),RIGHT(t.cidno, 4))= '{1}'".format(
name, idnum_cat)
cursor.execute(cmd)
ret = cursor.fetchmany()
使用了mysql的连接池,可是如果并发数量大的话,还是比较慢,请问有什么办法可以提升连接性能?